I know that this trait adds some more fun to the game but other than that?
According to the wiki, there are a number of otherwise unattainable encounters that you can experience if you have the Wild Wasteland trait, including some in the DLCs.
Number of Wild Wasteland Encounters
These feature references to many popular movies/TV
Is it worth it? That's something only you can decide.
You can read up on the specifics of the trait on the Fallout Wiki article.
The biggest difference is trading the unique Gauss Rifle for a unique Alien Blaster. I think the Alien Blaster uses special ammo that you only find a very limited supply of while the Gauss Blaster uses MF cells. The Alien Blaster is pretty ridiculous though, zero spread and every shot is a critical. You also miss out on a few mini-nukes.
If you want the perk, get it for the humor. IMO it far outweighs the (fairly minor) gameplay changes, which I'm sure is intentional. It's basically one gun difference, plus a few mininukes, and if you're like me you never even use "too good to use" consumable items like that anyway.
I never take it. The Ycs/186 is far more versatile especially outside of vats and with the inclusion of max charge ammo. One to two sneak crits will kill every legendary creature in the game. You can also use scrounger and the brotherhood ammo reward crate in hidden valley to get 100+ ammo every few days. It is the ultimate sniper platform in the game and the unique laser pistol Pew Pew with the high crit chance attainable for laser weaponry through perks and challenges is comparable to the Alien Blaster in terms of killing power.