The attitude between what Meta says and what the flag hovertext says is conflicting. The flag hovertext says "flag for serious problems" and Meta's attitude is "flag if you need a moderator to take a look at your question or profile"
"Serious problems" has a very negative connotation(which of course tells people not to use it for anything but spam or offensive). Why don't we do away with that or possibly add a new button called "call moderator" or something like that and remove the option to select from "spam" flags and "offensive" flags?
Now I am not saying to get rid of the ability to flag as spam or offensive but rather eliminate the difference between spam and offensive and then break out the "requires moderator attention" into it's own button.
Before I joined Meta and started learning about actual uses of the Moderator Attention flag(noise answers, answers should be comments, a quick way to close your own posts etc) I had never used it because I figured I should only use it for spam or offensive and the Moderator Attention bit is just some way to further describe such a problem.