I guess it can be argued from either side, but most people will agree that having different Gods is much better, because you will get access to a wider variety of spells. Also, remember to value the advantages of mythical units to your cities geographical location when considering which God to worship. If you worship the same God, you will get more favour from that God but will still be restricted in terms of spells and units.