The problem in your hip/leg may be from something lower -- lumbar region. It's not uncommon to have issues at the top & bottom of the spine -- it's part of the price we pay as a species for walking upright.

I have the same problem with NSAIDs. My doc gave me a prescription for meloxicam, which is milder on the gut, and I can take 1 bufferred aspirin on bad days.

For the knots in you back/neck/shoulders, you might look into myofascial trigger point massage/therapy. Once we learned what to do (from a certified therapist), DW & I can help each other when the need arises. It won't help a messed up cervical spine, but the knots are likely from your body defending itself from the pain by tensing up, and things cascade from there, exacerbating everything.

Doc