I boil it down to this.......

Put a cam in the motor that makes sense for what you’re doing with the car.

In 95% of the motors people are building, there are compromises made as part of the build, for one reason or another.
The cam is just another component that almost always has some compromises designed into it, to make it fit within some parameter of the build that isn’t quite optimum........ whether from a cost standpoint, compatibility with existing components, or how the motor will be used in the vehicle(and pretty often.... all of the above).

How much power you’re trying to make is almost always several rungs down the ladder in terms of priority when it comes to figuring out what cam to use.