which has horrible issues with moderation and zealots over-blocking random things in videos

"horrible" is kind of overstated, I feel.

I use SponsorBlock and haven't had any issues. I enjoyed when it skipped 99% of an MKBHD video, it was kind of funny.

I've seen a Linus Tech Tips video where the seekbar was very colorful due to SponsorBlock, someone added all the sponsors, product placement and tangents into it.

I admit I've marked segments on videos, e.g. skipping cringy jokes when I find the presenter annoying.

To clarify, are you saying that these segments were marked incorrectly?

If so, then it is a plain case of internet vandalism. I would just ignore such segments.

But if the segments were marked correctly and there were too many of them in the video, that is the problem caused by the video creator, not by the community which publishes the segments.

They were marked correctly, but I had a feeling someone was sufficiently annoyed with all the fluff in the video, that they went to the trouble. I think it was the only time I saw an LTT video with that many SB segments.

Sponsor block may have issues for content creators, but as a viewer I don’t care; at all.

I mean issues in that they over-mark things that are unrelated, instead of just skipping sponsor-related segments.

You can adjust the settings to block only actual ads

Really? I've been using sponsorblock for years and I don't feel like I've ever seen any of that. It's pretty rare for me to go back and watch something that was skipped, and when I do, I generally feel that skipping it was the right call.

I mostly watch small to middle sized tech/sci tubers, and for example f4mi is a channel where i’ve seen this