There’s definitely a distaste for SxS amongst the locals who don’t benefit directly from the tourists aspect, however, I think it’s largely just more practical for a local to maintain one vehicle. You live in this area and you don’t spend much time driving on interstates. The guy who has the contract to clear all off the alpine trails of snow in the Silverton area spends more time on those trails than anyone as he’s out there with heavy equipment in April. He drives keeps for recreation. I only know of one Durango local who owns a SxS and he’s only mentioned taking it once…. upon a road I’d drive a Subaru.
That being said, Silverton is not “unfriendly” to SxSs, they simply reverted, after a 5 year experiment, to not making an exception to the state law for vehicles that are not street legal. Moab tried to ban them on the city streets but that ban was overruled by the state. As far as I know, nothing has changed there.