To be honest, the only scenario I remember playing more than once was the sci-fi scenario from Civ4
Beyond the Sword. I remember playing the colonization of the New World scenario from Civ5 once, and I've played the Viking scenario from Civ6 once. Either Firaxis needs to really, really up their scenario game or else I don't find scenarios very interesting.