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.