I think the DQXI system is a good compromise. Your main saves are at save points but those are pretty regularly spread across the world. However, if you mess up pretty bad in an area or your system freezes you can go back to the autosave which refreshes in every area.

If anything, save points serve as a reminder for me to save. I still love auto save though.