Can this be used metaphorically, like to describe a headache?
I don't see why not. There are no rules as to when you're allowed to use metaphors. The only thing about metaphors is that you can't assume that any you make up are idioms that will be understood out of context.
No. Probably not.