Usually this situation is only felt by most gamblers who want to double their money at gambling places, in reality they lose everything and regret their actions by promising themselves not to gamble again. The promise is just an emotional outburst due to having just lost money, but the reality is that (those who are addicted) find it very difficult to stop. I prefer to play casually without targeting something bigger, for me gambling is a game to entertain myself, so every money I spend is part of buying entertainment after spending a lot of energy on work.
People who want to consider gambling as just entertainment will certainly never feel sorry when they lose from gambling because for people with that kind of will they will continue to enjoy gambling even though they can't win after spending their money on gambling. I also can't understand when there are people who gamble by prioritizing their emotions, even though they could just think of it like you said so that their minds don't focus too much on gambling because not everything in life has to be related to gambling.
In the end, it's about mindset.
Gambling with a mindset of wanting to get rich quick or wanting to double your money, then emotions dominate when gambling, hence the words spoken by OP "this is the last time to gamble or want to stop gambling but when the emotions are gone they gamble again".
However, when the mindset of gambling is only for entertainment when tired, then of course we will bet with money that is ready to be lost, when we lose it becomes a common thing in gambling and does not cause stress. I believe that mindset is the most important thing in doing anything so that we can go through the right steps, this applies not only when gambling but also in trading, mindset is very important. So be wise in gambling.