I've lived here for almost 15 years, I love it, especially my neighborhood North Beach. And, you're right, the poop map app was blown out of proportion and used by trolls and other bad faith actors to make things sound much worse than they were/are.

But

Poop on the sidewalk is a common enough occurrence that you'll never catch me slipping up watching where I am stepping to avoid those land mines.

I've sent in reports to 311 (the source for the poop map data) quite a few times, as well. It'd probably be worse if business owners didn't often take it upon themselves to keep the area by their storefronts/parklets clean for customers and passersby

And north beach is one of the nicer neighborhoods, with lots of tourists.

Does it ruin my life or perception of the city? No way. I do wish we'd invest in more public toilets, or businesses would offer restrooms to non-customers though.

Also, poop is not the only thing to avoid stepping on even though it's the only thing that gets repeated by the trolls. There's occasionally food littered about, vomit (especially on saturday/Sunday mornings or after "party holidays"), the rare flattened pigeon. Probably other notable stuff I've dodged over the years but have forgotten about.

Come visit, but stay vigilant, pedestrians!