A.H.
I have a memory foam pillow and really like it. I am also a side and stomach sleeper and have been to a chiropractor and physical therapist for years to work out the kinks it causes in my head, neck, and shoulder!
Try to train yourself to sleep on your back. It is really best for good posture and prevents premature wrinkles on the face too! I have found positioning my pillow between my shoulder blades (even if the top of my head is slightly off the pillow) really helps support my neck and back much better than putting the pillow at the base of my neck. Also any chiropractor or PT will advise that flatter pillows are recommended over the fluffier variety.
I have also found Salonpas patches (kind of like icyhot) really help with soreness. I just put one on the affected area and the mentholatum and other ingredients in it really helps relieve the pain. I also found that if I exercise after putting them on really helps too. I think the stretching helps the medicine penetrate deeper into my skin. If all else fails advil is my go-2 drug of choice until my doctor prescribed celebrex and a muscle relaxer on those really bad days. (You can't mix advil and celebrex though).
Good luck!
A.