I had a, erm, friend from Sheffield.
It's definitely not cheap. That's a bit of a misconception.
It really depends on what area you're living in & what your standard of living is - same as any other city. Where I live its reasonably priced but I live in an old mining village... A 2-bed semi can get anywhere from 80-120k in our village alone, depending on condition and location within the village. Neighbouring villages can go higher as they're "more exclusive" / commuter.
Sheffield itself is a really friendly city, but nothing on size and hum of London.
Personally I'd avoid Gleadless, Manor / Manor Top, Darnall areas, as they tend to be rougher. We live in a country village on the outskirsts bordering on Derbyshire & Nottinghamshire. We're postally classed as Sheffield, but council classed as Rotherham. It suits us fine.
How busy are you wanting your home area to be? Are you looking for more urban with minimal commute into the city? Trains? (we have 2 trainstops in our village - approx 20-25 minutes by train into Sheffield, 15-20 minute drive into Sheffield at a non-busy time). Bear in mind with Sheffield there is no traffic bypass, so all traffic has to go
through Sheffield... We're relatively close to the motorway too, so again we've got access to pretty much everything at hand.
PM me if you want more info, as I'm not posting more details than this on a public forum.