We live in an area we hate and frankly, we don't cope! We are going out of our minds with boredom.
Similar situation re buying. We can either get a really good house or a really good area, but not both. Both would involve an extra 150k. So I am in two schools of thought: find the best house we can in an area we don't especially like but that fits a set of needs - OH having easier access to work, having a road infrastructure that is better than where we are so access to do tedious stuff like shopping is easier, not being on a housing estate (sorry folks, they give me the creeps). But the compromise is, the area is one we lived in before and wouldn't really choose to again. It's not quite as boring as where we are now, but there's nothing special about it, and there's no real community, but it gives the OH peace of mind about changing jobs due to access, and the quality of house we can afford there is far higher than anywhere else. Almost forever home territory, just not forever home area.
The second option is to buy where we love, busy town high street, nice people, absolutely stunning countryside that makes our heart soar. But that compromise is the housing stock. It's just not very diverse. Either ex LA 1970s house which are about 200 sq ft too small for us (and extending would not add much value, and they don't have big gardens anyway) or newbuilds where everyone around you can see straight into your house from every angle. And I would struggle with room dimensions due to disability. The area also has far fewer facilities.
With these dilemmas in mind, I am reminded of something a friend said recently: don't be afraid to buy an interim home to get you out of the awful rental. He is right, nothing has to be forever. I guess I am lucky in that I potentially have a choice between an area that I love or house that I love, it's just that I want my cake and eat it, but I can't have that. We're also FTBs with no equity, we don't have that extra 150k to fling around (and even if we did, it probably still wouldn't be my dream home).
So. Interim measures. Small stepping stones. Compromise on the house, or compromise on the area.
But, if you possibly can, don't do both.