I dislike wheat beers, so I'm probably biased. But I've used wheat in several recipes, and it's good for what I need it for.
I use it primarily for head retention. But there are many people who love wheat beers, especially fruited wheat beers. To me, wheat beer tastes like grape nuts only with beer. Fruit only makes it worse.
That said, I'm going to make Dude's Watermelon Wheat recipe this week. I think that will be a big hit with my friends, and make a nice summer cooler.
If you like German hefeweisens, or American wheats, then a wheat beer is right up your alley! Otherwise, it's a good ingredient for head retention in malted barley ales.