A set of cams won't wear out, so they should be good for the life of the engine.
Idle, low rpm driving etc will all depend on how aggressive the cam profile is.
Ranging from a standard idle to lumpy as hell. But the more aggressive you go generally gets bigger results. But you will sacrifice things like steady idle etc.
Some really aggressive profiles require different pistons due to the amount of valve lift and duration produced. But then we are talking full on race spec.