It's not so great on the superhero side of the fence either. I was created to infiltrate into the system, betray my friends and family and am responsible for a kid going missing for eight years and losing his arm, all without knowing what the hell I was doing. So, it's not especially awesome all the time.
That said, your dreams sound especially epic in terms of suck and I'm sorry.