You can buy them off the shelf, so they must be basically harmless. Take a couple more if the pain is really bad.
Pooled individual participant data from 280 placebo-controlled randomised trials found that high daily doses of a coxib or of diclofenac raised major vascular events by about a third, that every regimen studied raised serious upper gastrointestinal complications, and that heart failure risk roughly doubled across the class (Coxib and traditional NSAID Trialists' Collaboration, 2013). Observational data put the odds of acute kidney injury at about 1.7 times higher during current use, and about 2.5 times higher in older people (Zhang et al., 2017). The harm tracks the daily dose: pooled observational estimates put high daily doses at two to three times the serious gastrointestinal risk of low ones (Castellsague et al., 2012). Two things keep this from being alarming. The absolute excess is small for a healthy person taking the occasional tablet, at about three extra major vascular events per 1,000 patients treated for a year. And almost all of this evidence comes from sustained prescription-level use in people with arthritis, not from occasional use.
Over-the-counter status describes how a drug is sold, not how safely it behaves above the dose on the label.