What civ you are actually doesn't matter that much for what mana types are good. There's only 2 real exceptions that I'll cover: Death and Earth.
Every civ likes enchantment, water and body early. All 3 provide very useful 1st level spells, and enchantment's passive bonus is a nice little boon too, while Body also has a useful level 2 spell. Just make sure to check whether or not you start out with these types, as there's not much point to having more than 1 of any of these besides enchantment (and even that, I skip)
Spirit's crucial for any empire that needs to face enemies that cause fear - dragons, high level demons, and many undead. If you aren't facing these kinds of enemies and you don't plan to go dragonslaying, though, it's useless.
Mind is a solid sphere throughout. All 3 spells are useful but not broken, and the passive bonus isn't much, but it's there. Entropy's the same way, except that it causes harsh diplomatic penalties with all good civs and a couple neutral ones, so watch out for that.
Fire's useless for adept level magic but a great offensive sphere for when you get mages, and stays good once archmages come around.
Nature eats dick for most of the game but becomes really awesome once you get archmages. Project sphere.
Death mana can be awesome if you hoard it. But only if! Either build a summoning strategy based on making all your nodes death nodes + chasing the wonder that provides more death mana for free, or skip death altogether. Death without the bonuses it gets from being stacked sucks. Best done with a civ that starts with some, or a summoner trait leader. The Sheaim leaders combine both.
Earth's also one that benefits from being stacked, except instead of providing spells that power way up with multiple sources, it provides a serious passive boost that scales up that way. Again, if your civ starts with some, you're better off here. Khazad are best for doing this since they get a free earth mana, and they can't even get mages or archmages, so they have less reason to diversify their mana for spells.
Metamagic is useful if you want to switch your manas around. You probably do not.