I almost always try for river goddess, because I then shoot for + food from shrines, temples, and guarda (sp.), as I have found that combo to be unbelievably powerful. Its not only an increase to city and empire growth, its also a bonus to production because you are getting food from a 'free' or 'bonus' tile, so you can work production tiles and keep growing.
Most others are pretty niche. The % bonus to production is a good second choice, but that one gets gobbled up fast by the ai.
Most others are pretty niche. The % bonus to production is a good second choice, but that one gets gobbled up fast by the ai.