I've used Hoppes, RemOil, Ballistol, CLP, Mobil 1 . . . all of them worked; any question about cleaning/oil/solvent/grease will get many answers.
I like Ballistol since it gets the job done and is "safer" - don't need to worry about getting it on wood stocks (works great as a wood conditioner) and it's nontoxic. When I'm cleaning a milsurp, hunting rifle, shotgun or handgun with stocks, I can use it on every part of the firearm without worry. Some have concern it may weaken the integrity of wood over time - if I had a pristine M1 Garand or family heirloom SxS, I may look into a more specialty product - but for the firearms I use and clean regularly, Ballistol has worked well for me.
Brand loyalty can be strong in the gun community, much like with any specialty hobby/interest/application. Been using Ballistol for a while, and it's what I've stayed with - Also, I've found it to have great application outside of firearms. It's proven to be a good item to have around the house for squeaky doors, faded/dry old furniture, tools . . . anywhere general lubrication is needed. I feel I don't have to worry as much if it gets on my skin, clothes, wood, etc. compared to many other oils.
It does have a very peculiar and unique smell. Not noxious, but fairly strong, licorice-y, and it can make you cough a bit, so be sure to have ventilation/open a window. Worth noting as some (also with consideration to wives/family members who may be around the area) don't like the odor. I don't mind it much. Not as nostalgic as Hoppes #9, but I've gotten used to it.
Plenty of people use RemOil and view it in a similar way as I do Ballistol. If it works for you, great . . . You may end up trying some other oils down the line, whether by recommendation or out of pure curiosity.