Yeah that's true, I think a lot of people in the US don't understand this at all. Everything British seems fancy and expensive, and we assume they all live like Londoners.
But you are right that wages are not going to be great in Scotland or northern England. But a great strategy that works well in the US, and I suspect would work well in the UK, is to just spend a few years living as cheaply as possible in a big city like London. Hoard as much money as possible, then take that and buy a house in a cheaper area.
In the US it is possible to live in a place like San Francisco for a few years, and if you live with roommates and don't fall for all the trappings that Californians go for (like ordering DoorDash every day or buying Teslas), you can easily save enough to buy a house for cash in a cheaper area. This strategy even works for tradespeople like plumbers/carpenters.
Once you own a house outright, most other things are relatively cheap living on local wages and you can live any kind of life you want.
Anyone can do this same strategy, it works well. Maybe they won't earn enough to buy an _entire_ house somewhere else, but they can earn enough to afford a large portion of one.
Aiming for a world where anyone can live wherever they want for peanuts is just not a realistic concept. Even when you build densely like in New York City, there will always be droves of people competing for the space in whatever system you build.