To answer your question, yes, and no. Now I'll go into more detail.
I was doing some research on German marijuana laws last week, and I stumbled upon this: Germany: Cannabis Law - 420 Magazine
To quickly summarize what they say about coffee shops, there are "quasi-coffee shops", but they keep quiet to stay in business. For ones that are legal and well-known, you'll have to go to Amsterdam. But for one in Berlin or other areas in northern Germany (Hamburg possibly, and I'm sure Schleswig-Holstein has at least one, considering their tolerance is so high for herb), you'll have to find it by word of mouth. They aren't gonna go posting that online, because they'd get shut down.
Now, if you're only deciding on going/moving to Germany due to coffee shops, then I suggest reading the link I posted. The article isn't really that long, and it's full of info. Here's what I'd say: Even if you can't find a coffee shop, still go. Northern states tolerate anywhere from 10g to 30g (Hamburg and Schleswig-Holstein are 30g, Bremen and I think Berlin are 10g). What this means is, if you get caught with it and you're within that states limit, they'll just confiscate it. Sure it sucks, but it's better than the US where you go to jail for any amount. They're cops there are wicked awesome about it (I'm sure some of them smoke too). So I mean, I'd say go if you can. Worst comes to worst, you can smoke in your house. Eventually you're bound to hear about one of these "underground" coffee shops.
Also, Germany has a great system anyway. Free education, free health care, 6-7 weeks vacation, a great political system. I'm moving there as soon as my ass is outta college. I've found tons of reasons to do so (most recently being those pot laws
), and no reasons not to do so. Everyone I've talked to who's ever been there or lived there for any period of time says it's amazing.
Again, check out that link, I think you'll like what you find.
Anyway, hope this helped. Maybe I'll see ya there in a few years.