Best and worst types of neighbours

[Demetrios Kalligerakis]

I am looking at an SFR where it is across the street from a few low rise apartments which got me asking how that would affect rental as well as future resale ( I live in a higher priced area so appreciation is part of the play ). Wanted to ask if people think that this is a benefit or a hinderance?

This also made me think what other things make you avoid a property? I was originally thinking cemetery but I suppose it could be anything. Curious what folks have had issue with, did/didn't avoid and was that a good/bad choice?