I watched India play in Australia a couple of months ago, the Australian team and spectators thought they had it in the bag when India still had ten overs to bat needing a run rate of about 8 or so. Very casually, they remained in sight but still needed a very strong end, hitting singles and the odd double. It gets to the last couple of overs and India starts taking it seriously, the Australians start missing simple catches, Dhoni deliberately doesn't take a couple of runs to get on strike and in the final over hits the six of all sixes to snatch the victory.
I don't watch an awful lot in the way of either but the only time I can recall something close to that in the traditional form of the game was in the first Ashes test last time it was in Britain when England was hanging on at the very end playing for time, down to the final partnership with Panesar showboating and the medic coming on and time wasting.
Twenty20 is a very different animal to ODIs and test matches but is a welcome one.