If they are P4's then there is hardly that much difference since they all have the same bus speed.
If they are Athlon XP's then the 2800+ (333) and 3000+ (333) will be similar (except for the 3000+ with 400FSB) but the 3200+ (400) has more bandwidth available but only slightly higher core speed (than the 3000+).
If they are Athlon 64's then the 3200+ will perform like a 3.2ghz part. The 2800+ and 3000+ have half the L2 cache as the 3200+. That is the only difference between the 3200+ and 3000+ (same clock speed). So instead of clocking the 3000+ slower and leaving the L2 cache alone, they just cut the L2 cache and left the clock speed. IMO the 3000+ performs like a 3100+ part and the 2800+ performs like a 2900+ part. Clockspeed is more important that L2 cache for the most part.
Recommend:
P4 grab a 2800mhz. (Not enough of a difference between the other P4's for the price)
AXP grab a 2800+ (Not much difference between the other AXP's except the 400FSB)
A64 grab a 3000+ or 2800+ (unless you really want that 1MB L2 cache on the 3200+)
IMO if you are gaming and could put some money into a better GFX card or something else then don't go for the top end CPUs but grab something a little lower and put the money to use someplace else. If you already have all the other parts then go ahead and get the higher CPU.
Athlon 64 2800+ review (Includes P4, A64 results and even a Athlon XP 3000+) Link
Xbitlabs review (includes P4, A64, Athlon XP 3000+ and 3200+) Link
Then there's Tommy Boy's review which includes all of those CPUs (Except the A64 2800+) Link
Choosing between platforms...yes. There can be a big change there.
Choosing between CPUs on the same platform not as much.
Notice Athlon XP 2500+ and then the Athlon XP 2800+ scores on that review.
Of course the Athlon 64 3400+ is going to spank everything there. It has the ondie memory controller, full bandwidth and the fastest CPU. hehe
That's the A64 architecture talking there.