I oppose all forms of automation in roleplaying games. I don't want anything to be handed to my character automatically. I want to choose. Choice is what roleplaying is all about. It is one of the things that separates roleplaying games from first-person shooters.
Roleplaying is about making characters as individual and unique as possible. And any game mechanic that gets in the way of that, or works against that, is not a roleplaying game mechanic, as far as I'm concerned.
One of the areas in which Oblivion failed, in my opinion, is in automatically assigning the same four Perks to every single character who levels a skill. I don't want developer deciding which spells my characters get, and when they get it. I want to make those choices. I'm roleplaying that character, not the developer. The developer doesn't know my character or her story or her aptitudes.
I might want to make a character who has no aptitude for a particular spell. I might want my character to learn a particular spell at a later point in the game than the developer does. I don't want a developer telling me when my character should know something or when she should be able to do something (unless there is an extremely good reason for it). I want to make that decision for my character. Because making decisions about what my character can do and when my character can do it is what roleplaying is all about.