Flodden is widely regarded as one of Scotland's most ignominious military defeats; a battle that need never have been fought and a historical event that has been firmly engraved in Scotland's national consciousness ever since.