Auto-translated
The 1-3, 5 system suits me quite well. It should also be noted that the spells there are not entirely random (at least in the third and fifth games, for sure). There is a certain probability of specific spells appearing in a specific type of city. Furthermore, in the fifth part, high-level spells of certain elements have a zero probability of appearing for any city except the Academy.
In the 4th game, the system was also decent.
The system in the 6th game might have been good, but there are too few spells, and the choice is very limited. It would be more interesting if some spells were learned randomly, and some as skills (in fact, we see this in the fifth game. For example, counterspell, banishment, and all mass versions of spells are learned when the corresponding skills are present).
Options 4-6... It's hard to say, I haven't tried them.
I choose option 1.