The size of the substrate particles affects water retention, where smaller particles retain more water. A higher content of organics (e.g., coco fibres) also increases water retention. Also it is good practice to water, wait 10 minutes and then water again. And of course, when watering, watering so the water runs out of the drainage hole. Often the watering technique is lacking, not the substrate.
It is for you to decide whether it is frequent watering, or highly retentive substrate. I want substrate that does not need watering more than once a day in all but our hottest weeks. And fast draining as we have very wet fall and winter, normally.