Some of the best matches I have seen are India's two 1-run losses to Australia in successive matches. adhulayum the Chennai one in 1987 with a 4 converted into a 6 mid match, which effectively turned a 1-run victory for India to a 1-run loss. Drama, fun, skill all around.
The 1992 match was a classic, too, down to Sankatapathi lapped by Srinath going for the 4th run turning a possible tie to a loss.