How you weight the various factors involved with choosing a location varies by your stage in life. But a key consideration should be, "Do I want to live here? Does it accommodate my interests? Will living here bore me?" If you don't ask these questions the ROI will be less meaningful.
And to an extreme, as I purchased after retirement, "Is this the house and community I'm won't terribly mind dying in?" It's a damned odd thing to ask yourself, if like me, it's your final house, but you'd better do it, the devil with ROI.
And to an extreme, as I purchased after retirement, "Is this the house and community I'm won't terribly mind dying in?" It's a damned odd thing to ask yourself, if like me, it's your final house, but you'd better do it, the devil with ROI.