Surely that depends on many factors, just like using any other tool or process?

Does each test tell you something valuable?

Is the cost of implementing and maintaining that test less than whatever value the test offers? That is, is the test cost-effective?

Could you have found the same information more effectively some other way? That is, what is the opportunity cost of writing and maintaining that test?