The two expansions (G&K and BNW) converted it from a dud to really quite an enjoyable game. I play, both SP and MP with my mates. I'd have to say though that the unit mechanics work much better for SP than MP. Being unable to stack units means very long and slow turns when you've got 3 or 4 people in the same game. Micromanagement hell.
Also. Since BNW the Piety tree owns. Get as many holy sites (gold, faith and culture) as you can, +25% city gold from temples, reformation belief purchase any type of great person for faith.
Bookmarks