Pathfinder 2nd Edition Caster Spell and Focus Quantity

I was curious about Wizard casting vs Sorcerer casting. Looking only at quantity rather than versatility, and Lv 1-10 slots (Lv 10 not being referred to when I say "highest-level spells") instead of focus spells. "Lower levels" pretty much always means at least 2 levels below your highest level of slot.

I also might have missed some granted innate spells because...this already took like 5 to 6 hours on the last week before finals @^@

[b]Specialist Wizard:[/b] ★4th slots limited to school.
[b]Universalist Wizard:[/b] ★no 4th slots. DBI is once a level.
★Drain Bonded Item (repeat a cast of any level)
8• Bond Conservation (metamagic to repeat more casts of lower level(s) after Drain Bonded Item)
10•Scroll Savant (2-4 free scrolls of different lower levels)
14•Superior Bond (extra use of DBI for a lower level)
18•Second Chance Spell (repeat an enchantment spell that did nothing on another target next turn)
18•Reprepare Spell (10 minutes to renew an instant Lv 4 or lower spell slot, Substitution can work)
20•Spell Mastery (4 spells of different levels always prepared with their own spell slots)

[b]Total at 10:[/b] 20 slots+2 scrolls of lower levels, repeat 1 cast, metamagic to repeat lower cast(s) after repeating cast

             or: 15 slots+2 scrolls of lower levels, repeat 5 casts, metamagic to repeat lower cast(s) after repeat(s)

[b]Total at 20:[/b] 37 slots+4 scrolls of lower levels+1 2nd Lv 10 slot [b]or[/b] 4 slots of different levels, repeat 1 cast*, metamagic to repeat lower cast(s) after repeating cast, repeat 1 cast of lower level, repeat ineffective enchantment spells [b]or[/b] renew Lv 4 slots

             or: 28 slots+4 scrolls of lower levels+1 2nd Lv 10 slot [b]or[/b] 4 slots of different levels, repeat 9 casts*, metamagic to repeat lower cast(s) after repeat(s), repeat 1 cast of lower level, repeat ineffective enchantment spells [b]or[/b] renew Lv 4 slots

(Repeat is not a real word anymore.)

[b]Sorcerer:[/b] ★4th slots with no limits. (4th spells limited to bloodline, but not necessary to cast.)
4• Divine Evolution (extra highest level slot for Heal or Harm), [b]or[/b]
4• Primal Evolution (extra highest level slot for Summon Animal/Plant/Fungi. No love for blasties :< )
16•Greater Vital Evolution (extra cast for two spell levels)
18•Echoing Spell (metamagic to repeat an instant Lv 4 or lower spell next turn)
20•Bloodline Conduit (metamagic to cast Lv 5 or lower spell for free, once/minute)

[b]Total at 10:[/b] 20 slots+1 spell-limited slot

             or: 20 slots

[b]Total at 20:[/b] 37 slots+1 spell-limited slot*+2 different level slots+1 2nd Lv 10 slot [b]or[/b] metamagic for free Lv 5 spell once/minute, metamagic for repeating Lv 4 spell

             or: 37 slots+1 2nd Lv 10 slot [b]or[/b] metamagic for free Lv 5 spell once/minute, metamagic for repeating Lv 4 spell

Overall, Wizards have many more options for casting extra slot spells, and they more heavily rely on repeating spells already cast. Divine and Primal Sorcerers have an analogue to Drain Bonded Item and Spell Mastery for highest-level slots via their respective Evolutions, but the first extra slot is spell-limited (and the Summons don't scale super well), Greater Vital Evolution is 2 spell levels instead of 4 (though they retain the ability to get Conduit or an extra Lv 10 slot), and they don't have an analogue to Spell Blending if the Wizard chooses that, or answers to all of the "lower level" options for Lv 8 and below slots. Universalist Wizards miss out on a highest-level slot but could potentially cast more lower-level slots, Arcane and Occult Sorcerers simply miss out on more casts. Both classes have endgame options to cast more ~Lv 4 spells, Wizard requiring time to renew them and Sorcerer needing to conserve them/pick good times to echo.

...then I got curious about other casters...

[b]Bard:[/b] no 4th slots.
16•Studious Capacity (Enigma, extra cast for a spell level below highest)
[b]Total at 10:[/b] 15 slots
[b]Total at 20:[/b] 28 slots+1 2nd Lv 10 slot+1 slot

[b]Cleric:[/b] no 4th slots.
★Divine Font (up to 6 highest-level heal or harm spells based on Charisma)
14•Ebb and Flow (metamagic to repeat 2-action heal/harm on different type of creature)
18•Echoing Channel (metamagic to add 1-action heal/harm at new target onto 2-action version)
[b]Total at 10:[/b] 15 slots+0-4 highest-level heal/harm slots
[b]Total at 20:[/b] 28 slots+1 2nd Lv 10 slot+0-6 Lv 9 heal/harm slots, metamagic to repeat 2-action heal/harm, metamagic to add 1-action heal/harm

[b]Druid:[/b] no 4th slots.
20•Leyline Conduit (metamagic to cast Lv 5 or lower spell for free, once/minute)
[b]Total at 10:[/b] 15 slots
[b]Total at 20:[/b] 28 slots+1 2nd Lv 10 slot [b]or[/b] metamagic for free Lv 5 spell once/minute

[b]Oracle:[/b] no 4th slots.
18•Divine Effusion (extra cast for two spell levels)
20•Mystery Conduit (cast instant Lv 5 or lower spell as revelation spell, curse and all)
[b]Total at 10:[/b] 15 slots
[b]Total at 20:[/b] 28 slots+2 slots of different levels+1 2nd Lv 10 slot [b]or[/b] metamagic for free Lv 5 spell once/minute

[b]Witch:[/b] no 4th slots.
10•Temporary Potions (...kinda: 2-4 free potions/oils, which often have spell-like effects, 6 levels below)
16•Siphon Power (free cast of a spell one level below highest once/day)
[b]Total at 10:[/b] 15 slots+2 pseudo-spells?
[b]Total at 20:[/b] 28 slots+2 pseudo-spells?+1 2nd Lv 10 slot+1 slot

[b]General Level 10 rankings:[/b] S. Wizard 23+var, U. Wizard 22+VAR, Sorcerer 20-21, Cleric 15-19, Witch 15/17, Bard/Druid/Oracle 15
[b]General Level 20 rankings:[/b] S. Wizard 43-46+VAR+renewal, U. Wizard 42-45+BIGVAR+renewal, Sorcerer 37-41+free, Cleric 29-35+free, Oracle 31-30+free & Witch 30/32, Bard 30, Druid 29-28+free
[b]General results:[/b] Most casters only start getting/differentiating extra casts after Lv 10. Before then, [i]Clerics with high Charisma[/i] actually have the most slots at the earliest levels (how long they keep this advantage depends on how high the stat is), though with restricted spells, while Divine/Primal Sorcerers can gain a similarly restricted extra scaling slot, and Specialist Wizards tie with them until Lv 8, afterwards having the most potential/actual spells by a decent margin. Of course, casters with fewer spells tend to have more focus spells and other features to make up for it.

...and then I got curious about focus spell capabilities.

[b]Wizard:[/b] niche/poor-quality to dull but solid focus spells. Starts with 1 if Specialist. [b]Max 2[/b] in-class.
1•Familiar
4•Linked Focus (+1 FP when using DBI once/day)
[i]14[/i]•Double Focus
[b]Sorcerer:[/b] niche/poor quality to general/solid focus spells depending on bloodline. Starts with 1. [b]Max 3[/b] in-class.
1•Familiar
12•Double Focus
18•Triple Focus
[b]Bard:[/b] absurd number of focus cantrips and spells, mostly solid, some [i]very[/i] good (mostly for Maestro). Starts with 1 (Maestro 2) and a cantrip.
12•Double Focus
[b]Champion:[/b] fairly general/solid focus spells with a notable martial bent, and domain spells. Starts with 1.
4• Desperate Prayer (+1 FP once/day)
[i]10[/i]•Double Focus
[b]Cleric:[/b] niche/poor quality to general/solid focus spells depending on domains. Cloistered starts with 1.
8• Surging Focus (+1 FP when ally hits 0 HP once/day)
12•Double Focus
18•Triple Focus
[b]Druid:[/b] fairly general/solid focus spells. Starts with 1.
1• Familiar (for Leaf)
12•Double Focus
18•Triple Focus
[b]Monk:[/b] fairly general/solid focus spells with a slight martial bent.
12•Double Focus
18•Ki Center (requires Stance Savant [i]and[/i] MoMS, cast ki stance for free once/minute)
18•Triple Focus
[b]Oracle:[/b] slightly niche to fairly general/solid focus spells with a little more power but a double edge, plus domains (also double-edged). Starts with 2.
11★Double Focus, 3 FP
17★Triple Focus
[b]Ranger:[/b] niche to general/solid focus spells with a martial bent.
12•Warden Focus
18•Warden Wellspring
[b]Witch:[/b] niche/poor quality to general/solid focus spells and cantrip depending on patron. Starts with 1 and the cantrip.
★Familiar
12•Hex Focus
18•Hex Wellspring

So, yeah. There's a direct inverse between number of slot spells able to be cast and quality/frequency of focus spells, with Champion being a little weird and Wizard being absolutely desolate. By extension, general satisfaction with PF2 spells varies wildly while most class-exclusive focus spells tend to be enjoyed. There's definitely more that could be done with Wizard feats and capabilities, but their bad focus casting seems intentional (even if not necessarily sensible ([i]why do they have the worst refocus level [b]all they do is study[/b][/i])). They're very clearly meant to leverage traditional slots across the full spectrum of levels more often than anyone else.

And, honestly, having looked over the numbers from a bird's eye view, it seems pretty much fine? Deadmanwalking has written homebrew that nicely addresses the focus spells and various other things, if that interests anyone. Classes struggling to appeal such as Wizard will probably get more cool stuff in the future to make up for it. I really need a nap. Hopefully this helped someone, somewhere.