I've had quite big cams in old school V8's, Holden and Chrysler. I really like the feel of a cam "coming on". I always loved how I could alter the idle, lump and performance of my 360ci Mopar, due to a highly tunable Chrysler performance parts electronic dissy I fitted, and adjustable rockers. That, and the double pumper Holley 4bbl. What a sweet engine and worked so well with the 4spd manual. Lumpy as, but ran like clockwork, with huge torque all over the tacho. Even a few quite aggressive Sig Erson cams I fitted to 253's and 308's with stock distributor and Rochester or Holley 4bbl's worked well with trimatics and TH400's. Conversely my brothers 4spd HX had a Sig Erson TQ30 (reasonably mild), with all else stock, apart from the exhaust. With a 3.08:1 diff ratio, it was a bit of a pig to drive. No torque down low. So lots of riding the clutch and getting dusted by much slower cars off the line. There's a lot in the tune for sure.
Anyway, I'm being cautious because I just don't want to fu$k up the already awesome package in my Motorsport. I also don't want to necessarily throw $2-4k at a small cam, for minimal increase over just headers, cats and tune. Nor do I want to add a stally. So, I'm starting to lean back towards a two stage approach: initially just headers, hi-flow cats, CAI and a tune, I'm afraid. Then wait until I've had a chance to drive a cammed VF2 auto with no stally, before I take the plunge on a cam.
As an aside, does anyone know the specs on the W407 cam?