First home was affordable and a house - that was it.
Compromises - area was rough, on street parking, old property with some damp. I loved it, it was all MINE!
Second house was again affordable, but much better area, walking distance to a train station & small city centre with pubs & restaurants. Compromises - shared parking, house was three storey, tiny kitchen.
Current home - better area again, still walking distance to station, potential to extend, character, good sized rooms.
Compromises: small garden, no rear access except through the house.
If you're looking to start a family, I'd advise thinking about space for two kids and their junk, some outdoor space and proximity to your support network. If you WFH, space for that too.
After that, parking or access to transport, somewhere you can walk with a buggy, access to local shops, access to schools.
I'd not count out a house on its appearance (or decor like my MIL did).