It doesn't matter. You know it's gotta be good when you get that Hive World up in that ♥♥♥♥♥.

Agri worlds are good for food
Penal colonies are great for mass slavery
Hive worlds are mega-good for everything except food production. Also, you can make them a Mega Hive, which almost doubles it
Shrine worlds are massively good for unity output and the spread of spiritualism


You get the point. Use common sense on what you want.