Many of us on this forum have tried, or currently use, CBD. Most people find that unless it is combined with THC it does very little for fibromyalgia pain. But this is a highly individual thing, so if you want to know you will just have to try it and find out. Be sure to start with a very small dose and work up to a higher one if you don't see any results. And don't buy CBD over the internet, because there are many places that are scams and you'll be paying a premium for just coconut oil. You have no way to know what you are getting if you buy it on the internet. Get it at a dispensary.
For me, CBD alone does absolutely nothing. combined with CBG and THC and a few others, it can definitely help, but it is not something I can use all of the time because I don't want to be stoned.
You mention that you have tried cutting down on sugar and so on, but I am wondering if you gave those things a long enough time to make a difference. Changing diet to the most healthy diet you can possibly manage will help because it will improve your overall health and strength, making your body better able to handle everything including fibromyalgia.
But cutting out sugar, or gluten, or any one thing like that in order to find out if it will help is something that you have to do very strictly (meaning reading every food label and making sure there's not one atom of sugar or gluten or whatever in what you eat), and do so for over a month in order to know if there's any effect. Just reducing your intake of something won't do anything. If you haven't done a total ban on the thing for long enough, you have not really found out if those things will help.
What your doctor said, while being rather dismissive and certainly not helpful to you, is actually pretty much true. Doctors don't know much about fibro, and none of them can tell you what diet or medication will help you because we with fibro are all so different that what helps one person won't help another. We've had people on this forum say this or that medication ruined their life, while others said it gave them a life. So again, you just have to try things to find out.
The other thing the doc said is, unfortunately, also true. Fibromyalgia is a condition defined by having chronic pain and other various symptoms for which no medical cause can currently be found. So the doctor was actually speaking the truth, although it seemed ...and no doubt felt....as though they were blowing you off. Not very nice for them to have spoken to you that way, though, not helpful. Fibromyalgia is real even if they don't understand it.
Medication doesn't help everyone, and most of us who are taking some form of medication have been through many that didn't help before finding one that does. If we even find one that does.
There are things you can do that might help, and suggestions for these things are given in the post called "My advice for managing fibromyalgia" at the top of the General forum.
What can also help, at least a bit, is to know you are not alone, and we are here for that. We can tell you what things worked for us and what didn't, and there are many options for that. And we can encourage each other and be supportive. We welcome your questions and your participation here.