As an aside, back in the 2e days, we tried an experiment. Clerics didn't choose their spells. They just had the slots per day and could cast whatever spells were on the cleric list as needed.
Funny thing was, 99% of the time, the cleric was casting pretty much exactly the same things - lots of heals and cure X spells, the odd buff, that sort of thing. But, I did get to see Snakes to Sticks (the reverse of Sticks to Snakes) cast which was the first and only time I had ever seen that spell used. No one in their right mind would memorize that. IME, it was a great success.
Then again, this was back in the days when clerics had virtually no directly offensive spells. So, it did make a lot of sense.