No direct experience with "Hot Cams," but some general comments, and a vague, nebulous answer to your question follow.
Valve lift, duration, and overlap (parameters controlled by the camshaft grind), ideally, work with the SYSTEM of the engine's fundamental design (displacement, compression ratio, aspiration, exhaust, etc.).
Thus, a "performance" camshaft is dependent upon the total system in which it presumes to play a role.
Now, for the (unsatisfactory) answer to your question:
ONLY if your engine "system" can take advantage of the valve lift/duration/overlap offered by an aftermarket camshaft can you realize its potential value. Implanting a "performance" cam in an otherwise stock engine is a step on a path of diminishing returns, IMHO; YMMV.
Someone may drop a Hot Cam into a stock KLR650 and set the World Land Speed Record at Bonneville, but unlikely in my view. A coordinated system approach, on the other hand, can profit from "performance" camshafts.
My opinion only; others respected.