We've had these before, and I'm sure we'll have them again. Questions that aren't great questions, questions that probably deserve to be closed, that also touch on taboo topics... (most obviously and frequently using the sex tag)
Normally close worthy questions would just be closed, and we'd wait for the original author to edit the question into shape. Optionally people will leave comments asking for clarification, and offer guidance on editing, etc.
These questions present something of a unique issue because of the obvious optics issues. If not worded carefully they can easily cross into rude/abusive, but I'm not referring to rude questions, nor am I referring to questions that would fall into the pick-up category. These are just not great questions, that have to do with somewhat taboo subjects.
For example the now deleted: https://interpersonal.stackexchange.com/questions/19714/i-want-to-have-sex
By all means this question should have been closed. No question about that. The question is, should these be immediately deleted? If they are to be immediately deleted, what's our reasoning? How are we to explain this reasoning to new users? How will we define "looks bad on the front page", if that's going to be our reason? Who decides what "looks bad"?
Basically it looks like we may need transparent, consistent policy for these cases moving forward. What should that policy be? And how do we want it enforced?
If we end up treating these questions differently than other bad questions, we need to be willing and able to justify that, out in the open.