Pathfinder 2 is even worse in that regard. You have a few kind of okay ones and then a bunch you’ll essentially never use. The price of Pf2s strife for “balance”.
It's probably my biggest pain point with the system. I have a buddy who only likes to play magicians. She's miserable playing 2e because the cool evocative spells she gravitates towards just aren't the narrow list of reliable, evergreen, and efficient spells that thrive in 2e's ecosystem.