In my next campaign I am going to curate various PC options at the start of play to reflect a somewhat grounded fantasy world. The actual campaign is a sandbox in the wild full of wonder and magic and horror, so that stuff will be discoverable during play.
By far the biggest list of things to deal with is spells, so i thought I would crowd source a little, if you would be so inclined.
What PHB spells do you think would fall into different "rarity" categories (common, uncommon, rare, very rare, unique). Note that it isn't really about power level so much as what would be found in a functioning civil society. That is, fireball might be rare (in the hands of the military-arcano complex only) not because of its power, but because it would be controlled. Stone to Flesh might by very rare simply because it has been lost to time, while Raise Dead and similar spells might have been actively suppressed.
Note also that most of the reasoning is just background flavor. The characters will be exploring the Land Beyond the Wall and discovering ancient spellbooks and magics written on the walls of tombs, etc.
Thanks!