Over the years I've had aqua therapy, ultra sound heat therapy and electrical stimulation both for muscle issues and also a herniated disc with sciatica. These provided limited and temporary relief, and in some cases, actually seemed to aggravate my pain. For the past 6 mos. I have been seeing a very good and skilled neuromuscular massage therapist and I believe I've found the most benefit from her. I had seen another massage therapist for quite awhile before, and that was sometimes beneficial, and sometimes actually did bring on flare and/or more pain and problems.
Like everything else, your specific areas and problems will respond in their individual way. Be careful of therapists who think they are going to adjust you and that's that. I also have fibromyalgia and when I first tried massage therapy it made me feel awful afterward for a few days. I learned I better handled 30 min.sessions more often than a less frequent hour long session. Eventually I realized I was no longer making any progress with my last therapist and talked to lots of people before trying my current one. She's a genius. It's like anything else - sometimes you get lucky, sometimes not. If I had given up after getting my very first "complimentary massage" years ago, though - which made my back hurt something awful - I'd be missing the benefits I feel I'm getting today.
With your issues and tight muscles I don't like to hear "it will hurt like hell". I think that sounds like a red flag. My massage therapy is not the "relaxing spa experience" that some people think or expect it to be. It causes some moments of discomfort, *not out and out pain*, and occasionally I'm hurting a bit the next day. But the location and severity are what supply the clues to the therapist for the next time. I'm told to take notes and I do. We go over the problem areas, changes, new pain, improvement, etc. at the beginning of each visit and she compares to the last visit. She checks my SI joints each time to see if they are "stuck" again. We plot progress. She tells me what stretches might help, using a very individualized method.
Also - I had several PT's, 2 massage therapists and one doctor tell me I needed orthotics. However, the difference in leg length is only 3/8 inch and my insurance won't cover anything under an inch. I've tried OTC inserts and finally quit trying to get it right. Oftentimes it aggravated the pain, or so it seemed. I have found the gel insoles (in both shoes) to be helpful, though.
Good luck - I hope you can find some measure of relief. Just be careful and go slow. I probably shouldn't say this, but sometimes I think the average PT treats every body/muscle injury the same - and the same recipe just doesn't work in every scenario. Look for somebody who understands the body, not just the method.