Shining Armor has it good.
He's on the top ten list of Canterlot's royal guards and in line to be leading them, he's inches from a promotion, and his marefriend thinks he can do no wrong.
Then the boner to end all boners throws all that right out the window.