Currently I am in a protracted war with they Yor. I have 38 colonies, they have 29.My global planet settings are uncommon as well as resources. It is turn 386. I am power level 2450, they are power level 2440, at one point they were higher. The rest of the ai are about 100-300 points below us.
Regarding the resources we are discussing I have on average about 3-4 of each one EXCEPT , the tourism ones which I went and bought up from all the minors and other majors simply to boost cash so I could rush buy stuff. I am doing about 2100/bn per turn and my production prime is 540 for the capital and 280 for its neighbor planet. I am cranking LARGE hulls out ever other turn. I have not reached Huge yet.
Over all they (the stack-able resources) are nice but so far are not the tipping scale unless....you grab many 8+, which equates to 40% increase in whatever: Movement, or economy or happiness.