You never want to buy at the top or bottom of a neighborhood, makes it more difficult to sell.
100% on buying the nicest house in the neighborhood. However, we bought on of the worst houses on our block. Previous owner had it for just over 30 years and didn't do any maintenance. At all. Nothing.
We put some money into it, and it's now one of the nicest. Best believe that our return, if we were to sell it, is much greater than paying a premium for a 'done' house.