My favorite kind of magic involves a more metaphysical and sometimes bullshit subtle style of magic. For instance, some of my favorite shit is Lord of the Rings. How magic is often the same as influence or just "power" and it is used by both good and evil.
With that said, I am also a fan of bombastic elemental/arcane spells and weird mutation/chaos spells and curses. However the best "magic" is where these types of spells are specifically called "spells" and magic isn't just the purview of magic users; everyone does magic to an extent. Magic swords, for instance, should also be forged by the most skilled warriors/blacksmiths, never by a "Magic User of X level and Y crafting feat". Sucks all the energy out of magic.
Also also; complaining about D&D and magic user balance is low effort, low hanging fruit. Change magic to be what you like instead of mindless regurgitating some meme.