I am speaking from experience on diesels and performance gas engines...
But in my experience a "Hot Cam" gives up low end power in favor of higher top end power.
It can pay off for some people and their riding style though if they tend to hang in the mid-upper RPM band.
It might not work so well for people who idle around, hit lots of technical sections, ride in loose terrain where wheel spin is a fun sucker.
This is all me talking out of my ass as I work on big rigs all day. I have built performance engines (AMC, VW, Cummins,etc) but haven't messed with a bike yet.
2014 WRR R.I.Pieces
2012 WR450F ECU, GYTR tuner, Q4, MSR rad guards, Cycra Pros, and a growing wish list...
This is exactly what I have experience personally (wr450) and seen (CRF450X)
It seems that HotCams cam profile and timing (Stage two specifically) is designed to give you increased power, and lots more acceleration, as they push the power increase into a much smaller rpm range. There is a very noticable 'hit' in the power, and a reduction of the low end across the board.
Stage one ( a 'torque' cam): pushes all the power down to 2000-6000 rpm
Stage two (a 'race' cam) slightly less power from 2000-5000, and much more from 5000-8000
Stage three ( a race cam for high compression and port work motor) 5000-100000
They don't seem to make a 'more power' cam, that widens the entire power band.
I would stick with changing to the wr450 exahaust cam only, and not the intake, as from what I have read the 400/426 intake cam is actually more agressive than the 450 cam