I am a ham operator and have been for 55 years. Yes there are "ham snob" who looked down their noses at CB. But these same folks view the newer no-code, amateur radio operators as appliances operators. They are old and they will pass. :)
To the OP's question, adding a CB depends on what you want and where you are.
As pointed out, the days of driving down the road chatting with other CBers are long gone. It was a fad popularized by a very active sun spot cycle and media mania.
For those of us who remember it, you could at times "work the world" or often several hundred miles, with little more than a 5 watt radio and 108" whip antenna.
Today with a magnetic mounted short antenna, a car to car range is about 3 miles or sometimes a bit more. They were handy when we would run a caravan on family trips. This of course has been replace by cell phones. Where there is cell service.
About the most useful function left, is monitoring the truckers for road information. A simple hand held can do that.
I cannot comment on city usage but it was not very useful the last time we listened but that was many years ago.
By the way, the Smokey warning really is not necessary when I am usually towing 10 mph under the speed limit.