The Link in Kevins post shows that Charts, there not all entirely accurate, probably because it doesn't take into account of the different Gearbox Ratio's across the Gearbox Model range, but is good enough for comparisons.
If were talking, in real life, 3.0 / 3.2's Ive done comparisons (mainly on Plod's and MV6's) 3.0 Manual with a Auto Diff (3.9) for increased 0-60, 3.2 Auto with a Manual Diff (3.7) for increased economy and am about to try a 3.2 Manual with Diesel Diff (3.45) also for increased economy.
the Manual with with a 3.9 did give a slight improved acceleration, 1st was a tad short, but became quite annoying at 70mph in top on a cruise (was purring away at 3000 rpm) so you felt you kept needed to change up a gear, so guessing a 4.2 would be out of the question for normal day to day driving.
Auto with a 3.7, remember looking for improved economy here, didn't seem to make bugger all difference in both 0-60 or economy in everyday driving, probably due to the Autobox Torque making up the differences in Diff Ratio,
, possibly a tad better on mpg on a 77mph cruise if driven carefully but nothing to shout about or make it worth while in my book.
And the 3.2 Manual with a Diesel Diff (3.45), have yet to do this one and mainly geared to one of my 3.2 LPG Manuals for improved cruising, I reckon with the extra gears to play with on the Manual box you shouldn't see too much of a loss on the 0-60 over the Auto, but hoping to see an improved mpg in 5th over 50 mph or on a Motorway cruise (We shall see).
As for maxed out Power and Top Speed differences. no idea, well not on a UK internet anyway.