There are no heros among us! What happens now?!!
I like you position Osvir, having a player who has Agency as Jwestfall points out is probably key to really enjoying a good story or game. One character that comes to mind that would have been fun to play in the way you suggested is HK-47 in Knights of the old republic II. You have a very evil creature, who depending on the main characters choices, a very good alignment path. He's along for the ride and he doesn't mind chopping up a few meat bags along the way.
I think ultimately if there is a way you could have the best of both worlds play a character whos personal actions reflect your own desire and follow a story path that is polar opposite. With the examples of HK-47 from KOTOR2 and Moonglum from the Elric novels.
I don't know if any of you have watched the Rags to Riches series on youtube based off of Oblivion, Skyrim. CVG creates a goal of making X number of dollars for their player Olaf so he can buy a fancy house. **Semispoiler ahead**The catch is he can't do any quests or adventures. He is bound by mundane tasks. There are 13 episodes around 7 minutes each. The reason why I bring this up here is because there is an episode where he 'hires' a hero to basicly do some things for him that he can't do himself. At this point someone else is having the adventure and he's along for the ride. The show, to me, was super fun and again illustrates there may be another facet to the RPG story telling that we are passing over.
At the end of the day we all want a well polished game that is fun to play. These kickstarters give us a chance to really ask the question, "what do I really want in a game"? Conversations like these are always beneficial because it lets us talk about what we love (which the game creaters are looking for) and really evaluate if there is room for something new or different.
I love character development and being connected to the world I am in and exploring. I also like a bit of tactical grinding. I'm sure my thoughts are the miniority here because, hey if it was a popular idea it would have been done already!
I didn't see anything in the terms of service about posting links, so if you wanted to check out that rags to riches series here it is! http://www.youtube.com/show/skyrimragstoriches