If you have records of being prescribed a drug before it’s fine to mention if it worked if asked.
It’s always best to never mention drug names and instead lead them on with symptoms AND effects on quality of life (can’t sleep, can’t work etc). Working is the big one - if doctors get an idea that the drug is the only thing making it possible for you to stay employed, they care more about this than how you actually feel. I noticed this naturally throughout my life but then spoke to a doctor and said that they formally use employment retention as some sort of metric for successful outcomes.
Then they are going to come at you with a bunch of non narcotic or shitty drugs like SSRIs first….so research the side effects and say you had too bad of X side effect to continue it.
You reach the narcotic prescription by knowing all the symptoms and alternative treatments very well and being able to talk about them and the doctor gets lead to the narcotic through elimination of other treatments….not by being directly told or hinted at a narcotic.