I an ot saying to house rule everything. Only to make getting finger death scroll harder as getting a bow that can OHK enemies on a failed save... If you make scrolls easy to obtain and weapons hard, obvious those who rely on scrolls will be better than those who rely on weapons.
You are seeing D&D like a mmo, with DPS, tank, CC, healer, etc when that is not the case. When people don't like something about a game or wanna something new, people MOD it. For example, i love Gothic 2 but be unable to learn Magic from Xardas(the same guy who teaches circle 6 on G1) is a huge disappointment. So i downloaded a huge mod called returning that not only adds the option to be a necromancer/dark magician but also made the game far harder in almost all aspects; dragons for eg, you can use fear + shrink monster and punch then to death. On ret, they have health regen, summon army of enemies, cast circle 6 magic(highest in the game) like fire rain and storm, and only by being 300m near the fire/cold dragon lair, you take heat/cold damage.
Most people who play D&D games use home-brew stuff, so if having a pyromancer instead of wizard that can only learn spells with fire descriptor can be fun for you, play with that class. Dread necromancer class is a class only about necromancy and i loved to play nwn2(modded) with it.
And most D&D games use homebrew stuff too. Slayer form who exists on BG2 doesn't exist on P&P.
[img]
https://vignette.wikia.nocookie.net...nd.gif/revision/latest?cb=20170811120157[/img]
Anyway, i started to play Dark Sun(1993) today and casters are insanely harder than melee warriors. Because arcane magic is hated in that world. My fighter/cleric is lv 6 doing amazingly on melee and at range with almost 3x more hp than my "preserver wizard" and my wizard can throw on fireball per rest. I can pick few spells per level up and a color spray scroll could be sold for 3000 gold.