My experience is this .
The first house I bought was just before the crash of the early 90s. For reasons I had to sell it and I had to borrow money to pay off the negative equity ( relationship breakup and OH refused to pay anything - I just wanted rid of the house and him
2nd house - I made sure the repayments were well within my means so that even if interest rates went up ( not to the 11% etc of first house ) I could ride it out
3rd house Lovely and I miss it but the mortgage was bigger - when DD went to university it was too big
4th house - it is a tiny worker's / artisan terraced house. I wish it were larger & as per previous poster , you would think you could buy something better for a few hundred thousand pounds but it is near shops & as my mother says , you can only sit in one chair at once. We have an office / pullout bed as a spare room & it works. But the monthly outgoings are very manageable.
So my advice is
Is your house an investment or somewhere to live. ? I think nowadays do er uppers don't typically gain money other than general house price inflation. But if you want to live there for a reasonable period of time and are prepared not to have everything perfect all at once it can work.
Be realistic as to what you want and what is on offer for what you can afford. My house has compromises - but most do . I do have friends who won't compromise on anything and want a glamorous house.
If you can afford the house ( with a buffer ) and it suits your family you can probably ride out the ups and downs of the housing market.
That to one side - my sympathy for those who are finding it hard to get any mortgage at the moment
Just thoughts . I am refusing to look at what my house is now worth because I have no intention of moving. But never let the perfect stand in the way of the good. A friend of mine gave me some wise advice once about buying a house . Make a list of your 6 must haves. Then cross out 3 of them & see how you go - worked for us so far. Sorry if not entirely relevant but hope it might be of interest - will ask to be deleted if not