From my experience, the cheating resources follow this scheme:
Hard = 50% bonus (1.5 times the normal rate)
Unfair = 100% bonus (2.0 times the normal rate)
Cruel = 200% bonus (3.0 times the normal rate)
Vicious = 300% bonus (4.0 times the normal rate)
If you're playing vanilla or Entrenchment, you'll want to stick to Hard or Unfair for the AI. As normal just can't expand quick enough to be a threat. Diplomacy fixes this somewhat, so that Normal AI can work well enough for larger team games. The Hard AI can provide some pressure, and you'll likely be on the defensive for a bit. With Unfair, it depends on the map size. Some maps are just too small for you to win against an Unfair or higher AI without serious struggle.