Can't comment on the other platforms, but as a freeview user, I got so fed up with regional lockouts and the 'sorry we can't screen the current program in HD' (or whatever it says) on BBC1 HD that I stick with SD all the way now.
Say for example I'm watching the 6 o'clock news in HD and want to carry through to the local regional news too at half past. No chance on BBC1 HD, so I just don't bother with it any more.
And besides, I have a top-flight HTPC under my telly and with the power of a full PC and GPU behind it, it does the most amazing job at upscaling SD. The output quality exceeds anything I've seen from freeview set top boxes, or the tuner built into the telly. Sure it's far from HD, but it's not a pixellated mess of lego bricks either.
I record a shirt load of stuff too, especially anything with adverts. I can't justify swallowing up 4x+ the amount of disk space to record in HD over SD either.
I do buy films on blu-ray and appreciate HD for that. But for run of the mill TV viewing I don't find HD important at all.
I think broadcast HD is overrated too. It's compressed to buggery and don't believe it is anything close to representing HD at its very best.