Oh yes, I highly recommend playing the Scifi scenario and the Fantasy scenario modes that come with ToT. They both have 4 unique worlds and are very very fun..
I really enjoyed competing with alien factions to colonize multiple alien worlds in the scifi scenario, you'll notice that each alien world has custom animating terrain and even full story descriptions when you look each one of them up in the pedia that really adds immersion. There's an old tips and strategy thread I posted some stuff in back when I played it that you may find useful if you have a go at that one...
https://forums.civfanatics.com/threads/lalande-21185-civ2-test-of-time-sci-fi-game.313815/
Some screens of my game from a few years back...
If you end up trying the fantasy stuff then I haven't tried regular fantasy mode however I did try the big prebuilt Midgard scenario that uses the fantasy mode. Gorgeous worlds, nice cutscene videos, and really cool unique races with different units with advantages and disavantages. The only issue is the complex events setup for the scenario story are kind of wired together like a chirstmas tree and are full of bugs. Catfish made a patch that fixes most of them though!
https://forums.civfanatics.com/threads/tot-midgard-woes.382827/#post-9679186
There's also an old tips and strategy thread I posted some stuff in back when I played it that you may find useful if you have a go at this one...
https://forums.civfanatics.com/threads/test-of-times-midgard.151248/
And here's some screens of my Midgard game...
And yeah fans have some some amazing stuff with the multi world features
@JPetroski and
@Prof. Garfield used it to create a night time strategic bombing layer that destroys city buildings in the regular day time world in their Over the Reich WW2 scenario.
@Kestrel used it to do a whole bunch of solar system colonization scenarios including an extended version of the good old Mars now scenario that allows you to dig underground and made cities beneath the surface and also go back to earth and re-colonise there. But that's just scratching the surface.. there's so much more out there too.
Over the Reich
https://forums.civfanatics.com/resources/over-the-reich.27172/
Mars Now Expanded
https://forums.civfanatics.com/resources/mars-now-expanded-scenario-tot.28875/