As far as Vancian magic is concerned, I'm used to it. Been using since 1977 and have never felt a need to use some other kind of magic. Truth tell, I can count on one hand the number of casters I've played in 30+ years, as I've always preferred martial characters. Actually only a few true fighters, I've played mostly: monk, rogue, ranger, paladin, and rarely multiclassing as a caster.
I've got one player who almost always plays a psionicist. Sometimes he plays a wizard, and sometimes a cleric, but almost always multiclassing as a psionicist. Me, I can't stand psionics, but I won't begrudge a player from wanting to play a specific class, no matter how much I hate it. (I can't really explain why I hate them so, it doesn't seem logical, but they've never sat right with me.)
Actually, most of the players that play casters in our group prefer spell points to Vancian. But when I send an opposing caster against the party, he doesn't use spell points, rather Vancian magic only.
D&D is not the only fantasy RPG that I've played, however. I played Runequest (the original), dabbled in Rolemaster and HARP, but D&D covers the bulk of my fantasy roleplaying over the years - like 95%. And fantasy isn't the only kind of RPG I've played, but I prefer fantasy to most other genres.
There are other magic systems and they seem fine within the context of the games they are played in, but I just as soon play D&D (or Pathfinder now) than any other game system.
Vancian magic has never been the albatross of my preferred game, but then it could very much be, that since I don't play casters in general, that it doesn't detract from the overall game, at least for me.