Er, I don't think we have enough of the appropiate units to make a true biblical apocolypse, although we could do more of a modern day faction one, still ending in the end of the world, even with cults and religions, but not quite what you're looking for.
Also, I think this should be posted in the 'civ-4 creation and customization' forum, this is for completed scenarios.