I don't throw tantrums and don't guilt trip people, but I go into a depressive mode each time something doesn't work out for me.

It sounds like I have a really fragile ego, and quite a big one.

Your ego is fragile because you believe you are not 'good enough' so a setback hurts real bad, confirms your inner (wrong) voice that tells you how 'useless' you are.
ITS A LIE!
You are as good, and valuable as everyone else.
Everyone gets setbacks, but because they feel good about themselves they bounce back pretty quick, whereas I would spend sleepless nights worrying, worrying, worrying, did I say the wrong thing? do the wrong thing, was I an embarrassment? like father said? Was it true that 'no one would ever like me' Like mother said?

Narcs make crap parents.