Bethesda did indicate that there was a slightly special save feature for consoles when it comes to mods:
So, we will at least have an un-modded version of your save, in case a mod "breaks your game".
I believe in addition to the various autosave triggers in Skyrim, one of those was "open the menu X number of times" so that if you were bumming around the same general location for hours without doing anything important it would still autosave occasionally. I can't remember if X was configurable, but I think it was because I changed it early on to be more frequent. I'm hoping that the save games will be automatically sorted by character, so that instead of a list of my 1000+ saves I can see my 15 characters (9 of whom I don't remember creating) and dig in from there. Extra points if they also have separate autosaves per character.
Good news: It's been confirmed that we can respec upon leaving the vault.
If that was directed at my post, I'm not talking about just corruptions. The tendency for BSG game scripting and mods to potentially cause problems effects everyone at some point. While that's not directly a Save Game issue, without frequent saves, it can massively screw you up.