I've been trying to get a hold of a Berlinerweiss, for the last 2 or 3 years during random trips into Germany and have always come away empty handed. A friend recently made it back from Berlin with 2 bottles of the "regular" Berliner Kindl Weiss and one of the green bottles with the woodruf syrup premixed in.
-It's medium-sour, and is a really nice "clean" sourness, it has none of the "funk" associated with a lambic; it's not very "beery" tasting drink and is quite pleasant. I was told that it's traditionally drank in large wine glasses through a straw so this is how I tried it. I've only tried one bottle of the regular so far but the first week of January, when I get back to Dublin, I'll be trying the version with woodruf. (My same friend also ended up in Leipzig for one day and was trying to find a bottle of the even rarer and stranger "Gose" style for me but came up empty handed.) -Gose is basically a Berliner Weiss but is brewed with Coriander and has added salt to give it a SLIGHT saltiness; obviously it's not even remotely compliant with the Rheinheitsgebot, but it's the next style I want to try.
I think Berlinerweiss is a GREAT introduction to sour beers, especially if you're not ready for the CRAZY high acidity and funk in some unblended, aged lambics. I also think it's a beer with a TON of potential for experimentation and blending in lots of different ingredients and fruits. (It's a beer that can be "dangerous" if brewed wrong, but one that I've been researching for a while and that I think I could do safely sometime if I'm willing to "infect" a corney with lactobacillus.)
The sourness is very different than a Flanders Red, too so don't automatically discount all sour beers; give Berliner Weiss a try; it's a nice gentle sour compared to many lambics or Flanders Reds. (But doesn't have the backing sweetness like the few Flanders Browns I've tried.)
Edited to add a picture of just how green the Woodruff syrup added version is: [img:3orqzug2]http://farm6.static.flickr.com/5202/5330227373_c3587c324a_m.jpg[/img:3orqzug2]
Adam