How did this thread turn into a DRM discussion?
First of all, Steam has not been confirmed as being mandatory for this game, but as they used it for Fall Out New Vegas, and I think I read somewhere that they really like Steam, I think it is quite realistic to assume Steam requirement.
Secondly, you do not need to be online all the time to play a Steam game after the initial install check. You do have the option to turn off automatic updating (for example when you are on slower connections). There might be some occasional on-line checks from Steam needed, but you can certainly play the game for days without having to go online (even if you turn off your computer at night). I am pretty sure it wil be clearly written in the requirements that on-line checks are required, so when buying the game you will know this.
If you are worried that Steam is taking up space/ressources from the game on your computer, you should seriously consider buying a new computer. Steam uses a couple of megabytes of resident memory and CPU power that is so small that it is very difficult to measure.
Going back to the original request, as set out by the OP, I just wanted to remind that Oblivion and Morrowind (as far as I remember) were both developed for consoles and then ported to PC. Oblivion (and FO3 and FONV) has IMO a terrible user interface from scratch, but as has been mentioned that is what mods are for. So based on the history of Bethesda role playing games, I am not sure why people are so worried about the PC version of Skyrim being relatively worse compared to Oblivion and Morrowind in that respect?
But I do agree that investing 100s of dollars in PC upgrades feels a bit empty when all games are being developed for the lowest (hardware) denominator = consoles.
And again just to make it 100% clear: Steam does not require you to be online constantly after the initial install check.