This is based on Hernan Cortes, who in 1519 destroyed his boats (although the burning is a later invention) to stop his men from mutinying and returning to Cuba. Thus motivated, Cortes' men helped him conquer the Aztec Empire.
Cortés, famously, scuttled his fleet off Veracruz during the Spanish occupation of the Aztec Empire from 1519-1521. He didn't burn his ships, as is the common misconception, but scuttled them to prevent some of his men from fleeing. This essentially stranded the force in Mexico, and is likely the historical basis for this incident in your game.
In 363, the Roman emperor Julian (called 'the Apostate' as he was the last Pagan emperor) invaded Persia by crossing the Khabur river on a "bridge of boats" and then ordered the boats destroyed after all his men had crossed to prevent his men from thinking of returning instead of pressing onward.
This is a rather famous teaching from Sun Tzu in The Art of War. The gist is that, before a big battle, you destroy all your cooking equipment. That way your men know they have to win and plunder in order to survive.
Since your question has already been pretty adequately answered; I'll give you an opposite case. The Spartans get a lot of credit for being brave and die-hard warriors (most likely more than they deserve) but the Athenians were actually pretty brave as well.
When the much stronger Persian army attacked, the Athenians all left Athens and the men went to live on their ships, ready to fight the Persian Navy. In fact, they burned down Athens so that the Persians could never use it for themselves, and also so that no Athenian would be tempted to leave their strong naval position in seeing the Persians threaten his home.
In 310 BC the Greek general Agathocles did this as well during his invasion of Africa to attack Carthage (Third Greco-Punic or Third Sicilian War). After 6 days at sea, he landed 110 km from Carthage, and burnt his 60 ships so his men couldn't count on retreat (he only had an army of 13,500). He dedicated the burning of his ships to the goddesses Demeter and Core, purportedly as propaganda since the Carthaginians had committed outrages to these gods in Sicily.
Historical sidenote on the campaign itself: he actually did quite well at first, capturing many towns along the coast, killing many of Carthage's leading commanders, and threatening the city of Carthage itself. Supposedly, at the low point in the war Carthage sacrificed 200 high-born children to the gods to curry favour (with a further 300 citizens volunteering to do so as well). After a violent revolution in Carthage and mutinies in Agathocles ranks, as well as reversals in the war in Sicily, Agathocles left Africa for Sicily (I guess by this time he had new ships). His son was left in charge, and the Carthaginians switched to guerrilla tactics. The Greek forces split in order to chase the scattered enemy forces and were cut down in ambushes. Agathocles returned to Africa and found the war was now unwinnable. He couldn't evacuate his army, so he just fled himself, leaving his forces (and 2 sons) behind to surrender to Carthage. Peace was bought, as Carthage was on the brink on financial ruin from this war, and the Greek forces were spent.
Source: Carthage Must Be Destroyed: The Rise and Fall of an Ancient Civilization By Richard Miles
burmese here. Yes. some time ago (I forgot what dynasty) King Ba Yint Naung and his foot soldiers had a battle on shore and the king set fire to the "phaung" (square floating boards made of stacks of bamboo) so that his men couldn't flee. It boosted their spirit to fight and led the battle to victory.
The real historians have answered the real historical question, but since this is a question based on Warcraft III, we should also consider the Burning of the Ships at Losgar to be an important source for this story. Of course Tolkien's mythos drew from many historical sources too, but it's very possible that WC3, like many fantasies, drew from Tolkien rather than from the historical source material directly.
But when they were landed, Maedhros the eldest of his sons, and on a time the friend of Fingon ere Morgoth's lies came between, spoke to Fëanor, saying: 'Now what ships and rowers will you spare to return, and whom shall they bear hither first? Fingon the valiant?' Then Fëanor laughed as one fey, and he cried: 'None and none! What I have left behind I count now no loss; needless baggage on the road it has proved. Let those that cursed my name, curse me still, and whine their way back to the cages of the Valar! Let the ships burn!' Then Maedhros alone stood aside, but Fëanor caused fire to be set to the white ships of the Teleri. So in that place which was called Losgar at the outlet of the Firth of Drengist ended the fairest vessels that ever sailed the sea, in a great burning, bright and terrible. And Fingolfin and his people saw the light afar off, red beneath the clouds; and they knew that they were betrayed. This was the firstfruits of the Kinslaying and the Doom of the Noldor.
There's something similar to this in Roman mythology. In the Aeneid, the ships of Aeneas sort of left port of their own volition once the Trojans had disembarked onto Italian shores. It was a "no going back now" kind of statement.
My follow up question, in the WC3 campaign Arthas framed some mercenaries for burning the ships, when this happened in history, how was the destruction attributed?
True but the soldiers will still die UNLESS they surrender to their enemies. I guess the principle is to make the troops believe they have nothing to lose, killing their General will only diminish the chances of winning the battle.