The raising stakes one is definitely one a lot of people fall victim to. I have even been a victim myself numerous times over the year, e.g. I'll just keep doubling up until eventually I win.... Until I get an unlucky streak and lose a lot of money. People need to understand statistics, they assume that they are the only score that matters, when in reality they are part of a cohort of people which constitutes the average. Just because extraordinary events seem unlikely to a single person, across a cohort it is quite possible, and the more times you double up, the more chance you're going to get screwed.
It is called martingale and you are absolutely right here. Actually, it is extremely tempting to use this strategy because it works most of the time and for the same reason it is extremely dangerous. You can increase your balance 10 times with it, but when you lose, you lose it all and your balance becomes zero. One might think "Okay, I'll just double my balance and withdraw immediately", but there's a big NO to that. The thing is that with martingale you can lose everything before managing to get
any profit, let alone doubling your bankroll. I personally lost a lot in the past to martingale on dice, but this strategy is so tempting that I still use it from time to time, but not with the purpose of earning money of course. I don't gamble in order to earn money, that would be suicide.