Also as a librarian, the degree of caring can vary based on where you are. Lots of people don't care about the smut right up until you actually mention it or do something like direct them into a pit that has toddlercon tag groups (i.e. AO3
).
Where I'm at actually has had the patronage throw a fit about stuff that gets too blatant, and our director generally has us be fairly careful about what we put on the shelves vis a vis that sort of thing* (we have neither the funding nor the staff to deal with folks pitching regular shitfits, sadly). There
is a fair amount of smut on the shelves, but meaningfully signal boosting it would probably catch us more flak than anyone involved feels like dealing with. Shrugging when a patron's browsing something like AO3 is one thing (drawn or video porn would be a different one; kids in library etc., etc.), putting the library's name behind it would be another.
... mind you, the exceptions can be fun. Director had us get a new copy of lady chatterley's lover fairly recently, part of some kind of all time whatever books. The trick was it had a classic genre label on it so we were pretty sure no one would read it even if it was displayed fairly openly :V
* Now, ILL or whatev' we give zero shits about. We wouldn't put straight up porn on the shelves but if there's another (in-state) library that has it, give us a buck to handle processing and postage and we'll get that porn in your hands.
All that said, Best Related Work specifically looks like it's always been kinda' weird. Hugo in
other categories is probably still fine even if this decision has tanked your faith in the thing. It's pretty understandable in some ways how it got the nom and subsequent award (AO3 itself has a little twitter blurb where they asked folks there when they got the award that were involved with the site as users et al to stand and co-accept and like half the bloody auditorium stood up, including many of the people involved with other nominees), but... yeah.