Pls advise which drugs can be used for a rotator cuff tear which does not require surgery. Pain is moderate but ongoing, have full movement/strength?

Nsaids? Im not sure what you mean by a rotator cuff tear that doesn't require surgery. But at age 74, I would certainly try to decrease your pain and swelling with some nsaid medications Then Id work on improving your range of motion and shoulder strength with specific rotator cuff exercises.
Over the counter. medications can be used first including tylenol (acetaminophen) or NSAIDs like ibuprofen or naproxen. Heat/ice may help. If no improvement with these things then your doctor may write prescription for pain medications which come in several different varieties.