Last bet on normal game usually doesn’t provide a lot of tension because it usually just waste bet however all-in bet when player is already at huge loss can give a tension too but not the same tension on the topic because there’s already a choice to take profit or continue risking.
I think many of us have made all-in bets and that is something that is very Scary , but I Really do it when I know I'm going to lose and that I have no other option, that is, I do it when I am already resigned, it would not Surprise me at all , but sometimes when I am like that I win , and wow that is where I say that in the game one is under any type of Possibility of doing things right and doing them the way they have to happen , sometimes the casino, its house advantage is not so bad , we Know that they can and will win but we have a very good option even if we are resigned.