IMO If running higher boost, fuel to support, cams tuned/dialled in on a dyno, etc...
Intake cam 3sge gen3 manual (9.8 at 252) vs 3sgte gen3 (8.2 at 240) yes gains,
exhaust cam 3sge gen3 manual (8.2 at 236) vs 3sgte gen3 (8.2 at 240) no gain.

Gen3 3sgte was designed for the cams and rpm range. If you increase lift, serious consideration of upgrading the 20+ year old stock valve springs to match the lift, boost, rpm etc.

Check your head casting that the higher lift in camshaft doesn't catch.

The above redesign of an intake cam upgrade would be breathing more air in at a higher boost (lots of air in, chilled through your uprgaded intercooler to a nice 40 degrees), combustion :) and then trying to get the burnt fuel/air (at say 1,500 degrees) to escape at the same valve movement as stock (not going to happen). Challenge with that equation is more chance for recirculating exhaust gas (1,500 degree) not escaping the cylinder, that is bad news for engine temps regardless of your cooled intake temp and consequent deadly outcomes of longevity.

Ok thanks for the info guys, sounds like unless I were to get say aftermarket intake and exhaust cams as well as giving the rest of the valve train an overhaul its probably not worth changing my cams.
I was just interested to see if their may have been some easy gains to be had without going to in-depth overhauling the engine.