It might get more addictive but there's still not the same incentive to design for more engagement like on mainstream social media.
About NSFW content randomly popping up, I actually haven't seen any of it yet.
But still I wouldn't scroll any of the fediverse (or Twitter if I was still there) around people. Never know for sure what will pop up.