Hi Barry and welcome here!
Sorry to hear you're feeling so bad at the moment. Many of us have had to go from very active to pretty inactive and learning to pace and not overdo it is often hard. Have you managed to or could your flare have been caused by that? Have you been able to identify any trigger(s)? It's often a good starting place to track and analyze symptoms and possible triggers in a diary, I don't know if you've started doing that yet.
@sunkacola's
Big Advice Post at the top of the forums will help you for basics like that.
Meds and pain: Generally pain killers can not take the pain away, they only suppress it, only identifying & preventing triggers plus treating the overall and local pains as well as possible using the many physical possibilities.
Duloxetine/Cymbalta together with only pregabalin/Lyrica and milnacipan/Savella is approved for fibro by the US. Only amitriptyline has been proven similarly "effective" for fibro. But since all meds for fibro are proven "pretty ineffective" and we are all different, there is none that will take too much of the pain away and there is definitely no "best drug".
Since you say duloxetine/Cymbalta isn't helping the pain, I wonder why you are using it, is there any other good reason? If there is any other reason, like depression for instance, then I'd ask the docs to change (e.g. milnacipran is also for depression). Some people take quite a cocktail. I'd however suggest it's better because of side effects and general health to trial and learn different ways of getting the pain down and to wean off of any meds as soon as possible.
It is well likely if duloxetine doesn't help that others won't help you either.
So: Try changing if meds are stlll necessary, but >100 other strategies and treatments as soon as possible (mental, physical, diet, environment and instead of meds supps, each with 20+ possibilities).
Hope that helps - otherwise others will surely add to that and feel welcome to explain and ask more!