I agree that the question content and answers to the question should not tip toe around spoiling the subject of the questions but the title of the question should have some guidance. If I see a Question on a movie that I haven't seen or don't want to know details, I won't open it but it's difficult to miss spoilers when browsing the questions titles.
Spoilers in question titles should be avoided wherever possible. This is particularly important for movies that are currently in theaters / cinemas, or even early into their release cycle to other outlets like DVD.
If in doubt about how to phrase a question - say "Possible spoiler question about movie X" would be better than spoiling a current release. Ask people to edit the question to put a better title if necessary if you can't think of a way to ask the question without spoilers.
Once in the question itself, as you say, avoiding spoilers is generally not important.
If there is a movie that you are particularly interested about avoiding spoilers ... then add some "ignored" tags to your profile - these questions will be partially greyed out in the web interface.
We really need no spoilers in the title as the titles show up everywhere on the StackExchange network.
I don't even have to frequent this part of SE (I'm usually on StackOverflow or GameDev) to get title spoilers in the "Hot Network Questions" bar.
The question that brought me here is this one:
Here is how I handle spoilers, and I think this could be a general guideline:
Don't spoiler in the question title. If you think something in your question could be a spoiler, try to find a creative way to paraphrase it in a more general way for the title and go into more detail in the question body. A common example is "What happens at the end of XY" instead of "Why did character A kill character B in the end of XY". This is a slippery slope of course, because we want question titles that are as significant and expressive as possible, but I think keeping spoilers out of them where possible is just good sportsmanship between movies and TV geeks.
If possible, don't spoil in the first sentence. Not as hard a rule as the above, but because the Newest Questions overview shows a preview of the first two lines of the question, it is appreciated if you don't spoil right in the first few words. An introductory sentence giving a context to your question is always a good idea anyway, so this should not be to hard to do.
If it spoils the ending, use the ending tag. Seeing this tag should be a warning for everyone who has not seen the movie/show yet.
If everyone follows these simple guidelines, I think we could browse this site pretty much free of involuntary spoilers.
Here is an exemplary question of mine where I applied those personal guidelines: Was the ending to "How I Met Your Mother" planned from the start?