Yeah it is painful, I am still hurting from a relationship I ended 6 weeks ago.
She was a potential lover, we danced and snogged, but then she friendzoned me. Now its just me but I realised recently that it really pisses me off being friendzoned, and it doesn't work with me, I will always resent that person, so it is better to make a clean break not drag on trying to be a friend but wanting to be a lover, but this person I really loved.
So I messaged her, 'Sorry to disappoint you to, but I want lovers not friends. Please never message me again. Bye.' I think it annoyed her as much as she annoyed me because she really needs friends! Still missing her though.