Quote from Occam:
Stops end up being a setup for you to exit at the worst possible time
Sometimes, yes. But frequently if price is trending towards your stop, then it will continue trending in that direction after it hits your stop.
And why would you even consider them unless you're either overleveraged or unconfident in your position?
It doesn't have anything to do with lack of confidence. Most traders will have 40-60% of their trades end up losers, so you need a mechanism to get out of a loser. How are you supposed to exit a trade if the price keeps running away from a limit order?