The only bad thing which wasn't tested and why I no longer use Hoppe's as a firearm storage oil, is Hoppe's turns to "varnish", (for lavck of a better description), that gums up the firing pin in bolt guns (bolt action, pumps, semi and fully automatic firearms) often causing the firearm to malfunction or to be totally inoperative. Not so much but I have experienced that same varnish/gum to cause problems with the cylinder lock on revolver not fully operating properly.
I've had a similar problem with Frog Lube (the liquid kind, not the paste he had in the video). This was disappointing, as Frog Lube seems to be the only one where my wife tolerates the smell. I've taken to cleaning with Frog Lube, wiping it off, and then using RemOil when she's around. Otherwise I clean with Hoppes #9. My other option is to just stick with Frog Lube, but do a thorough cleaning before going out. Even gummed up, it prevents rust. On the other hand, if I'm using it daily, or weekly, it seem to work well. I'm happy to take it to the field, because I know I will be using/cleaning enough that it won't have time to gum up.
I, too, do not like the smell of Ballistol. I thought it would be "the Thing" for use on the old Luger, but there is better.
Back in my Machine Gunner days, we broke all the rules, and only used CLP if anyone was watching. To clean the piston on the M60E3, Easy Off oven cleaner worked a treat. We didn't use that on the rest of the gun, as there was a fine line between "cleaning" and "removing all the bluing". On the rest of the gun, we used carburetor cleaner, then a light coat of CLP. I had a friend who worked at a garage, and he was able to get me an "available only to the industry" product from Castle called "DragonFire". This fine product, in addition to being hell on carbon, left behind a dry lube. We always seemed to have fewer jams on guns that were regularly cleaned with that product.
The internet is a wonderful thing: I haven't thought of that stuff since George H. W. was the Big Guy, and yet it pulls right up in a search: https://www.barnesperformancecycles.com/products/castle®-dragon-fire™-carburetor-cleaner-14oz