Yep---It's You..........................................................!

then you will never be happy.

 
Instead, except the pleasure you do get and keep going treating each time as an adventure to find more of what you may be looking for.

 
Can you even put into words exactly what it is that is missing?

Personally, seeing a few different ladies every week wouldn’t work for me either. If I wanted to see a lady frequently, it would have to be an ATF that I built a real connection to, but that’s expensive and hard to find. Since I tend to hobby around, I find spacing them out more makes sessions better. If what you’re doing isn’t working, maybe try waiting longer and building the anticipation up more.

There would be no shame in that. This realm isn't for everyone. But there are a number of red flags in what you said that suggest there may be some truth to what I am saying.
.
If you are genuinely bored most of the time with beautiful women who are eager to please you sexually, then maybe its time to leave p4p behind and try the civie online dating, perhaps.
.
I'll admit that some dates are better than others, but I can't honestly say I have ever been bored in p4p. I do get burned out from time to time, but that's something entirely different. For me, the solution is to take a break, and maybe that's what you need too.
.
Stepping away and reassessing can be a healthy thing. Take a month or two off and see how you feel afterward. If you don't miss it, you will ll have your answer. That approach has always worked for me, which is why I intentionally build breaks in and step away from the demimonde two or three times a year. I almost always come back feeling refreshed, rejuvenated, and excited about it again. In the very rare case I dont, I stay away a bit longer until I do.
.
Maybe what you need is a little self care is all. The one thing you said that genuinely concerns me is that you feel the need to be "heavily on substances" when you play. I am not going to ask what you mean by that specifically, because that's your business and not mine, but it might be worth looking into the reasons as to why that is. Tbh, at a first glance, it does sound unhealthy, however.
.
I am not judging you at all. It may simply help to have someone you trust, possibly a professional, to work through some of this with you, sort it all out, and offer guidance, support and a different path. Give it some thought, give yourslef some time and good luck with it all.