Good Morning.
I wanted to share on this as I have had similar issues with my "pain in the butt".
Long story short, I recently had surgery on my hamstring/tendon and had debris removed.
I have attached what was removed. Pretty significant and it was agreed that this was the source of the pain that I was having in that area. It is hard to saw the cause, except at this point I can say goodbye to the pain that I was experiencing.
I had seen a couple of doctors for the hip and was told that they couldn't help (and didn't tell me anything else). I did see an medical orthopedist-sports medicine physician. Conservative treatment (yet again!) but different and I was ok with it. I was able to communicate with the doctor well. After a year it got interesting as the pain did not go away and I could no longer do my favorite activities. I was sent to the surgeon. Initially I was laughing about how I would look using crutches (being a physiologist I thought I had failed myself). Yet, after going through the processes that the surgeon suggested (surgery wasn't the first one). I said: "Enough is enough" and got on the line to get the outpatient surgery done.
It went as the surgeon expected. There are different degrees of surgery for this problem and the rehab protocol has similarities- and differences. The surprise was the amount of debris (bone) that was removed. The repair was easier than what could have been. The recovery is non-weight bearing for 6-8 weeks with progression based on how long the individual takes to HEAL.

I am at week 8. I was told to keep "chill" and follow PT until 3-4 months (I like to think it will be longer) before I get to ride a bike and lift weights (legs) again. That is what it takes.

The surgery went seamlessly and knowing what I do now would work with the team again to bring the same outcomes in future.

As of now I have no pain in the area (except for the incision site). That is a game changer! Hope it helps. Don't give up. It took me decades to get to this! Happy I did.