I have mixed feelings about it. I don't consider D&D to be super-duper serious, but I also don't like constant, in-your-face humor. Rary is fine because I can ignore the epithet. Gleep Wurp, not so much. Ripping a name straight out of a book (Aragorn) kinda sucks, but hacking it a bit (Eregon -- this happened before that book series was written, okay) is fine, even if everyone knows from whence it came.
I've allowed archers named Bosomethingorother, shortened to "Bo". But, I nixed a WoD character who was a psychiatrist name Luna Sae (the player didn't even realize what she'd done, but I couldn't unsee it).
I guess that my answer is "I prefer reasonably serious, but not pretentious, names. I would, however, probably be more comfortable in a group of 'awesome' namers than in a group of self-absorbed method actors/wannabe authors."