Honestly from experience I've learnt that the yes answer also usually applies to the no answer because it's important to everyone. Advanced users tend to hit advanced issues and surprise, surprise, then community size matters all the same!

So since Linux is highly customizable and the choice of e.g. desktop environment matters little (just install whatever you want on any distro, including DE), community size is the most hard-earned property and thus usually trumps all.

So I personally try to keep closest to upstream regardless experienced or less experienced users => Debian if you adore those DEB packages and management, Fedora if you love those RPM packages and management, indie ones for indie packages e.g. Alpine, Arch... If you still run into issues it's usually you, not the distro because it's already battle hardened. :) But no worries, then you'll find a lot of help and the problem has usually already even been discussed and is googleable! It's 2023, none of the huge distros are plain shit and annoying, that's been ironed out like a decade ago. So just go with a (big) flow somewhere.

I think most who want NSFW in their feed simply subscribe to things from here https://lemmynsfw.com/

It's an instance only about NSFW. Elsewhere it is rare, yes. I think that's honestly good for Lemmy.world and others. Even if OP's suggestion on image hosts is good, if it blows up I expect a ton of people will begin uploading 4K porn directly on the instance.

So, anyway, as usual with subscribing from another instance, you go here and search for [!boobs@lemmynsfw.com](/c/boobs@lemmynsfw.com) if what you need is more boobs, then subsribe to that and voila it's as if it was here on lemmy.world.