Anything above 500k is not selling for a long while in my area some on the market for a year.
re fixed rates, these give you certainty at least. Most mortgages will allow an overpayment. In the early years it’s more expensive with setting up a home (more if having children) BUT things do change as you get through that phase so it maybe helpful to think of your property buying journey in chapters - while you are not where you’d thought you’d be now in 2-5 years time you could have a better mortgage deal or move - try to see the flexibility in the future
On a personal level what does this house mean to you? Is it quality of life, independence, pleasure from a space for a hobby, next life steps entwined with values thy are important to you.
Buying is better than renting due to what has happened to the rental market IMO
A good plot and location are top factors - a larger house has drawbacks: expense of boring and maintaining v financial security (if it’s more affordable less pressure) TIME and skills spent cleaning and maintenance, stuff goes wrong and it can take up head space, you will have rooms you don’t use! I’ve put the above to help serve as a little balance in adjusting to a slightly smaller affordable house.
There was a comparison somewhere I saw - the person who buys a smaller house less mortgage and still saves and invests is better off financially than the person who buys the large home with bigger mortgage.
House don’t give big boom returns from yesteryear hence up the ladder isn’t selling and some sources say we are midst a more subtle house price correction stages