Thinking of moving to Tallinn and buying a house / apartment - what are the best neighborhoods to look into, and which ones are the worst?

I've been doing some internet research into the city, and it seems like Pirita and Kadriorg are the better / more in demand areas - while places like Pohja Tallinn the worst (as far as I can tell).

Of course the old center is a prestigious place like most cities - but where else would be worth looking? Viimsi? Haabneeme? Haabersti? Kristiine? Mustamae? Nomme?

Some local insights would be very much appreciated. Where would be the place you'd want to move to if you had the option?

Thank you all!

Edit: thank you all for the responses so far. You have certainly been of help, I look forward to visiting and seeing these places for myself.

Edit 2: Wow - woke up to some fantastic responses today. Thanks for all the help!