A holding period of 5 years is too short to guarantee meaningful appreciation anywhere in Brooklyn.
If you are buying a place to live in for yourself that makes more sense than renting--almost anything you could buy makes more sense than renting right now!--I would focus on purchasing a property that is easy to sell in 5 years.
Because if you can't sell it for as least as much as you paid for it, you will have to sell at a loss to get your money out in 5 years. Most people do not like this at all.
There are easy to sell properties in all the neighborhoods you list here. It's not the macro location so much as the micro location--the particular block--and the specifics of the property itself.
Also, if you buy a place that needs some work and you fix it up, you might be able to turn a little profit when it comes time to sell. That's the way professionals make money in real estate during level markets.
If your time horizon can expand to 10 years, then purchasing a property that can be rented easily and at a good rent would be paramount. Not surprisingly, such a property is also easy to sell.
I know all of these Brooklyn neighborhoods well, I'd be delighted to meet with you to find out more about what you're seeking and find properties that will work out great for you.
Licensed Real Estate Salesperson
New York, NY