I used Google the other day to do a search for small sites with Civ2 scenarios. You never know what you'll find, and sometimes you come across a rare and exceptional find. I happened to find something exceptional.
Check out this Civ2 site.
http://victorian.fortunecity.com/carroll/238/
Although the page is small and holds only three scenarios, all three are VERY exceptional with some AWESOME graphics I have not seen anywhere else. Besides that, the scenarios are a lot of fun.