Indeed. Well, actually read the entire "Tales of the Dying Earth" omnibus.
The gist behind it is that wizards prepare for various situations by meticulously memorizing the right set of spells, as in there's some amount of planning to identify your challenges and the tools you'll need for a job.
That makes a lot of sense for pen & paper D&D, but in an RPG perhaps less so, as it means you can only cast a spell once. That leads to a number of things like tons of variations of what is essentially a healing spell.
As I said before, not really a fan of the ruleset in computer games, and whenever I play anything D&D I will, at most, go for a paladin, but never a full spell-caster because of the above. I tried a druid once in NWN2 and it wasn't fun at all.
Edit: Apparently the 5th edition D&D is more lenient in some aspects of spell-casting with a "relaxed Vancian" system. I may give BG3 a go at some point, see if it's any better then.