Overall.
The D&D wizard and it's mechanical are the anomaly. Gygax based the wizard on Vance's Dying Earth. Almost no "scholarly wizard not derived from D&D" looks or works like the D&D wizard. The continuation of the Vancosn wizard is a pure D&Dism. You don't see prepping spells from a spell book into slots often in media.
Most "wizards" in fantasy books, TV, and movies work closer to sorcerers with the ritual caster feat and have lore closer to the sorcerer.
The D&D wizard and it's mechanical are the anomaly. Gygax based the wizard on Vance's Dying Earth. Almost no "scholarly wizard not derived from D&D" looks or works like the D&D wizard. The continuation of the Vancosn wizard is a pure D&Dism. You don't see prepping spells from a spell book into slots often in media.
Most "wizards" in fantasy books, TV, and movies work closer to sorcerers with the ritual caster feat and have lore closer to the sorcerer.