Fantasy:
Dungeon: Heroes of Beckhorn is a favorite of mine
Modern:
Any scenario by Case is great, also, someone correct me if i'm wrong, but scenarios by Nemo don't have a lot of tech advancement.
Up the Deadly boot is another good one.
I really think your missing out on some great scenarios if you don't play ones that require you to discover new technologies
edit: if you look in the download section for civ2, you'll see that the scenarios are sorted by time period. I don't know what your favorite genre is, so you're going to have to find the ones you like the most, which is all part of the fun of civ2, playing it