As a fan of horror and the occasional porno, good and bad, I'm pretty chill with NSFW content. I also have a comic that focuses on mature themes, and shows occasional nudity and violence, so I would be a hypocrite if I weren't fine with it.
I agree that stories for adults have a lot of potential to be more than mindless porn, raunchy comedy, or mindless violence. You can touch on a much wider range of topics, have room for nuanced discussions, studies of character, tell a story that is more provocative or thought provoking. Although it's impossible, I sometimes wish there was a higher demand for adult fiction in the webcomic sphere, I feel like one of a tiny handful of people in this community who want to read and create stories for my age group. Doesn't help that more and more community sites like this, social media and other art related sites/apps are now pushing for censorship, discouraging creators from even considering mature content. This also perpetuates a negative view on anything mature and the few who delve into it.
Also when it comes to trashy messed up stuff, I generally don't mind, especially in indie works. There's nuance behind their decision when someone makes sexual assault porn, abuse stories, torture porn. Sometimes it is someone whose just gross, but other times the creators and consumers are victims or survivors of related traumatic experiences, and they use the controlled environment that is fiction/art to cope with and/or tackle their trauma. Which can actually be a good way to deal with those issues, and be used as a form of exposure therapy. Because of this I never judge a creator by the content the make, but purely by how they treat others and carry themselves as a person.
So yeah, I'm very much for NSFW/mature stuff.