They are used for arthritis, but they are simply more powerful NSAIDs, like ibuprofen, aspirin, etc. Arthrotec is nice in that it won't upset your stomach (unless you are pregnant).
Can't really give you odds, but unless it was a bad tear, it should heal up fine. Just don't use it for any real...