The surest way to appreciate the sheer flexibility of the wizard in Baldur's Gate 3 is to go play a mage in Baldur's Gate 1.
Go on. Hop to it. It'll be a life-changing experience, I assure you.
In any case, the real advantage to the wizard vs. the sorcerer, warlock, or bard is being able to learn spells from scrolls and just... have them in your spellbook at all times. The other wizard-adjacent spellcasting classes learn spells on level-up, which isn't too restrictive since you can respec with Withers, but it does mean that they lack the ability to freely swap prepared spells in and out without going back to camp and paying for a respec and going through the motions of DOING the respec level-by-level each time. So wizards can get a fair bit more use out of those situational spells, by virtue of not having as much pressure on them to choose between a situational spell at level-up and a more obviously flexible spell.
Have you ever played a wizard in BG2? If you reached lvl. 8 or higher wizards became cool. In DnD 5 they have mighty "cantrips" like Gandalf. Cantrips are stupid in general why do we need them? Because there are not enough spell slots. If we had enough spell slots we would not need cantrips. So the concept is stupid in general.
