As a general rule, utility without cost is an issue.
In 3.5e this comes because you have cheap wands and scrolls (or even just 'I leave my low level slots free, so I can solve any problem with 10 minutes memorisation time').
There are systems where wizards have limitless utility, and they still work, simply by imposing a cost on that utility (shadowrun charges meaningful character resources for spells and then each spell has the potential to cripple it's caster, mage allows on-the-spot creation of spells, but threatens the caster with paradox etc). Sure the wizard could cast knock, but it might kill him to do so.
4e has issues because rituals are so specific and ineffective that they usually end up without a niche where one might use them. They tend not to be able to do anything that a skill couldn't do instead, but they cost a lot of money and take a lot of time. It sort of swings the other way, to a place where magic is never used for utility and is instead reserved for killing stuff.
I think Shadowrun does magic best. It is my favorite system for it. I like the idea of magic taking a physical toll on the caster.
But Shadowrun mages have a better ability to do other things if they can no longer cast magic that does not make them feel useless. Which is an important thing considering that if you fail to resist drain you may only be able to cast one spell for the run. The mage I played was a fantastic shot with pistols and always had one or two elementals bound for service.
But as much as I like it I don't see it working as well as well for DnD. Casting one or two spells then being able to only fire crossbolts or if you feel daring wade into melee with your staff is going to make playing a wizard not very much fun unless you have other things for them to do.
I think one of the best fixes is to make scrolls and wands more expensive the downside is that would also make healing wands more expensive and force the clerics back into being more of a band aid for the party. Which makes a lot of people not want to play them.