Yes, I think it sounds very vulgar and stupid. I'm glad I'm not the only one. But I hate it no matter how it's used because it's a swear word and to me it's not mild and it ranks up there with the f-word. I get it though. Most adults, especially guys, don't want to say poop or poo because it's childish, and feces is supposedly restricted to doctors.
But using it in place of something generic makes the person sound a lot more childish and immature. "Today at lunch we had burgers and fries and s***". Well now, that literal picture in my mind sure does make *my* mouth water!

And then there's using it in place of words that rhyme with it in commonly used phrases such as "Are you kidding me?" or "I kid you not!" I guess if you use the word "kid", soon people will look at you like you just suddenly spoke a strange alien language. Ugh...
But is s**t really more offensive than poop or feces? s**t is the original word, it has cognates in several related Germanic languages as well (