The camshaft produces pretty small shaking shaking forces, even at significant rpm. I've spun up a bare SOHC camshaft on my test fixture at up to 5,500 rpm (11,000 crank rpm) with no rockers connected. There was no noticeable vibration on the machine.
Once you attach the rockers, the accelerations of the valvetrain pieces will create significant vibration. The machine would start buzzing pretty strongly at that same 5,500 rpm with rockers attached. This shows that the valvetrain accelerations totally dominate the camshaft imbalance.
If Rolls Royce wants to build a car with a 9,000 rpm engine, you might see a balanced camshaft

Until then, it's not worth it.