Don't forget you will have to figure this out when the weather is a bit clearer. But you will see fireworks in the entire Federal Republic of Germany, no matter what alley or main street you hang in. There are a ton of things to do NYE here...concerts, clubs, parties, Soho House roof could be good for fireworks and is a good hotel to stay at, too.