Having Auto Saves turned on, such as "Save on Rest", "Save on Travel", and "Save on Wait" can result in unintentionally overwriting another game save or character, which has actually become a problem for me.
My roommate uses my PC to Skyrim right now since his GFX card died. Well, I had a level 15 character with auto saving turned on.
He played this afternoon and right away his level 1 overwrote my auto save. Luckily I had manually saved a few levels earlier but it could have been much more worse, and frankly I was kinda pissed.
Well, I'd like to say I think Skyrim needs to have a better Save Game interface. Something like a character selection screen, and below it, or off to the side, a list of game saves for that particular character, whether they are [AUTO] or Manual saves.
Not only would it look good, but it would save the trouble of accidentally overwriting a friend or family's character.
I can only hope this could be a patch or a simple PC mod, but I would assume this might be trouble for the console version as well.