I'm not a bike mechanic. I'm just a guy who likes to ride bikes. Hopefully, some of the amazing bike geniuses in the forum can help vado5.0slcreo2 solve his dilemma. A few amateur things I'd add though are. Since it sounds like a primary concern is about safety, I'd check every millimeter of the carbon frame and the wheel set for cracks. If your bike has almost 10,000 miles it's not a brand new bike any more.
I've got a 2020 Vado 4 with about 20,000 miles that's had a number of issues over the years. Those bikes were notorious for the frame cracking underneath by the motor mount in a location that you'd never see if you weren't looking for it. It never happened to me, but it's happened to other folks in the forum.
After a few years of ownership, I did have a crack in the Vado 4's rear wheel by one of the spoke nipples. Even though the bike was out of warranty, Specialized replaced the wheel at no charge (probably out of concern for liability issues.)
At some point my Vado 4 had a mysterious clicking sound in the rear wheel. The local bike shop figured out it was the plastic guard in between the cassette and the spokes. They said was a common reason for mysterious wheel noise. They removed the plastic guard and that problem was solved.
I'm guessing that your bike is out of warranty? If it's not, then someone has to fix it. If your local bike shop has tried everything and can't solve your issue, consider taking your bike to another Specialized dealer. That's inconvenient, but it's worth a shot.
Like Calcoaster said, maybe it's a simple issue that no one has figured out yet. Don't give up!