If we are talking how heartbreaking they were AT THE TIME, I think 2003 Sox has to be first. The curse was alive and real. And it was a loss to the Yankees. Winning the next year definitely helps it feel less horrible in retrospect, but at the time there was nothing worse than that loss, at least to me.
Great job and list.