I enjoy gaining power far more than feeling powerless, which seems to reflect in my games library.
But starting out powerful and losing that power kind of feels like treading water. You're going from 0 to -X and back to 0 again at that point, and it's just nowhere near as satisfying as starting out at 0 and going up from there.
I'll gladly start out weak and helpless and then gain power, and knowledge, throughout the game. In fact I think that's possibly one of the best mechanics in games, at least according to me.
There's just nothing more satisfying to me than starting out in a game where I can barely defend myself, and then gradually grow in power to be able to make a stand and eventually become the thing everything should run from. Which means games that start you out weak, and eventually allow you to become really strong, are usually to my liking.
I mean I love Skyrim, Fallout (especially 2) and Far Cry 3 was the most fun shooter I've played in years. I just love games where I can get utterly destroyed at the start and then grow in power and ability to become the games top predator.
Been having my first go on Dark Souls lately, and I'm not really getting the same level of satisfaction that some of my favorite games give me. Though, it's still quite enjoyable (if you're a hateful masochist

). God damn I hate Blighttown...
I've also recently started playing Outlast (seemed fitting to play through it now), but I can't really tell, at least at this time, if I enjoy feeling that powerless. I mean I'd pick up, well, anything blunt or pointy after I ran into that crazy priest guy (I'm like 10-15 minutes into the game atm).
So I think Alien: Isolation might be more to my taste already. Sure, you can't actually kill the alien, and you pretty much remain prey throughout, but at least you're not defenseless.