While Skyrim has done many wrongs in regards to magic, you are simply making it seem much worse than it actually is.
I will agree that spell making should have been added either as a feature or as a skill in Skyrim but I will also state that the spell-making system was not well-thought and was quite broken in Oblivion. I will also add that the -% magicka system is stupid and that spells should have been a bit cheaper and weaker by default. The spells should have also gotten damage boosts with enchanting and destruction leveling instead of the -% magicka.
As for open lock spells, they make the already useless lockpicking perks even more useless and fortify skill spells are not needed in a properly balanced game.
I would also like to add that the way that spells are cast has been considerably improved in Skyrim and that is something that they should keep and expand upon.
Lets also not forgot that in skyrim the cast costs do not decrease nearly as dramatically as they did in oblivion, and as to what you said about spell making, it doesnt matter if ti was well thought out or not, they gave spell swords better enchanting, they gave warriors smithing to make them uber powerful, they gave thieves and assassins better alchemy to make them uber powerful, and completely screwed the mages by taking out spell making, they should have worked on it to make it better than flat out scrapping it. Let's also not forget the INSANE butchering of the variety of spells too, i dont care what anyone says, lockpicking spells should be there for a mage, period, mages should have the spells, warriors should be able to smash locks, and thieves can lockpick. And continuing, we lost spells to increase our resistance to magicka, thats ridiculous, we lost absorption spells, we lost carry weight spells, and for mages that used to like to enhance themselves with alchemy, thats no longer an option ,because lal the potions weight half a pound, even if the ingredients only weigh .2 when combined , which again would be no problem if fortify carry weight spells would still be there. The magic in system is an abomination compared to oblivion no matter which way you turn it. OH YEAH, and i cant block with my staff anymore, thats a little lame.