If you are looking for a place to live, all the mortgage maths only matters insofar as to gauge whether you can afford repayments.
I bought my house last year, just before interest rates went through the roof. It's an ex council house in an undesirable area and it hasn't seen much love from its previous owner (who was a landlord who, by the look of it, didn't know the first thing about DIY but did it all himself anyway).
In short, it's in a bit of a state, but it's all I could afford as a single mum of 2, even on my reasonable income (not high by MN standards, but in the top 40% of total household incomes nonetheless, and that includes households with 2 earners, so I must be doing well).
I view this house as an expensive piggy bank. Each year, I put in money and each year, I have more money in the form of bricks than I would have had if I'd stayed renting. And all without the risk of having to move yet again because someone somewhere wants to sell up. No surprise rental increases, though I know that my next increase in the form of higher mortgage repayments will come soon.
But then I overpay to the tune of what I'd have to pay once my fixed repayment % runs out, so I won't feel the effect of the increase too much when it comes. I was stress tested to 11%, and as a single person you have to be prepared for some ridiculously high stress tests. I used a calculator to see that I could, at a push, afford 14% by cancelling all my non-essential outgoings.
If you're looking for a place to stay in for a very long time with all the security owning a house brings (not being pushed out, being in charge of repairs and how/ when they're carried out, even just veering away from fucking magnolia walls) then just take the plunge in any house that meets your space requirement. Forget the ladder, forget even location (one slum I used to live in used to be a place of high desirability just 25 years beforehand). All that can change. Does the place have decent proximity to everything you need? Go for it.