One thing I really hate is when games throw High Level content at you super early in the game, just to take it away it again.
The most famous example was Fallout 4, where the game throws Power Armor and a Minigun at you in the first 30 minutes of the game. In all previous Fallout games, getting your first power armor was a huge late game thing. Really killed my excitement to get it that early. The fact that the first power armor is really awful and the fact you can't use it for more than 3 minutes thanks to the Power Core requirement just makes it worse somehow.
There was a also a really old Star Wars game where you START as freaking Darth Vader, with a crap load of abilities and an completly overpowered character. Just to switch to a random dude (without any force powers) in the second level. I really hated that - both parts, the starting overpowered AND the taking away the powers part.