I don't have enough fingers and toes to count the number of abuse reports I've personally filed that seemingly go nowhere.
OVH at least takes down the booters and other proper malicious stuff, but copyright infringement reports go ignored to the point to where I don't bother. CloudFlare, on the other hand, at best, just passes whatever I send in, and their upstream provider doesn't care either, so nothing ever gets done. It can feel like rackeetering with how much they enable all the things they protect you from.
That said, I think 99% of small sites, personal blogs, etc, really don't need any of the services offered; the most useful offering for most people is literally probably DNS.
Game servers and gaming-related communities, or at the least the ones I am most attracted to, are just about the only thing I think requires DDoS mitigation regardless of size. Our little Garry's Mod TTT server with a max player limit of like ~24 people would get attacked a couple of times a week at least.
And good lord, the RuneScape community is another breed of toxic; the way I learned to program was by reverse engineering the game, and we'd work on private servers that were essentially from-scratch MMORPG servers that just emulated the RuneScape mechanics and protocol.
One aspect of the game, though, is PvP -- when you kill another player in the wilderness, unlike in a lot of other MMOs, you get most, if not all, of their items they have on them.
I could perhaps understand DDoSing another player during combat in order to steal their gear. But what made me stunned beyond belief was that when I hosted a "spawn PKing" server (e.g., PvP-only, but you don't have to work for your gear; everything is free - it's just for fun), they'd literally lure each other into TeamSpeak to grab IP addresses and DDoS each other for.... nothing :)
(and so you can imagine also just how often we'd get hit with massive attacks ourselves)
The huge wave of DDoS extortion attacks that happened 3-4 years ago was mostly enabled by "booter" services that themselves hid from law enforcement behind Cloudflare.
Here is an example: https://therecord.media/feds-seize-ddos-booter-sites-in-late...
Feel free to punch any of the sites they mention into dns.coffee and look at the historical nameservers. All Cloudflare.