There are lots of proposals to limit spellcasting, and IMO this is one of the better ones. I don't like the "make a roll every level to see if you get that good spell, and if you fail you suck" that I saw in 2e.
A spell like fireball is very common, and not just because it's good. It's used by...