I love goofiness, fanservice, and goofy fanservice probably more than many of you. Hell, I enjoyed Let's Meow Meow for crying out loud. But sometimes, even I get annoyed by fanservice. Like in Agarest War 2, some of it (e.g. the oil massage sequences) felt like a tacked on afterthought and the game would have been better without it. That being said, I did find some of the optional event scenes really funny. Some bordered on creepy, but whatever.
And then you have cases like the manga My Balls. For the first couple of volumes, it's hilarious (if you enjoy lowbrow humor, obviously). But then it seemed to get old fast and overstayed its welcome. EDIT: I never finished it, but I heard the ending was good despite the supposedly draggy middle, so I'll probably read it again online just to see.
And while I was able to figure out Baten Kaitos and Ar Tonelico from the intro, I'm still stumped on the RPG about a flamboyant vampire pro-wrestler who beats his enemies with telephone poles. That sounds like a wild game.