http://www.civgaming.net/mercator/
http://www.fortunecity.com/underworld/virt...4/civ2scen.html
http://www.campus.ecp.fr/~pano/main_.shtml
Well those are just a few scenario pages that poped up in Google. If nothing else works - play a few scenarios and you'll get an idea what's good, then try and make one yourself. Keep working and playing it untill you're satisfied.