Losing in the last minute, against a team we weren't expected to beat, in a game we deserved to win is more gutting than losing a game in the first 30 minutes, against a team we weren't expected to beat, in a game we didn't deserve to win IMO.
I also nearly cried at that game but the Scotland - Italy game in 2007 is the only game that has succeeded in making me cry.