It is possible to screw yourself lategame by the usual Elder Scrolls "picked the wrong the stats to level". My first character was a cutthroat thief and I had to finish the game never alerting an enemy. If I didn't one-hit backstab kill and the alarm went off, I could not take any enemy that faced me. I wound up sneaking through the entire final dungeon and only beat Alduin by save scumming.

I always wind up as a stealth archer for a different reason. I love sniping, and I love stealth gameplay. So every character starts out as a noble attempt to be something else, but I inevitably wind up sniping from the shadows.