Either Dean following Sam to the grave, or both dying and Cas following, or all three dying in some epic battle. The angstier the better.
Please no illness, no AUs, no 2014 and no resurrections. 
Death may be involved because he's a BAMF and if he says there is no way bringing Sam back, Dean would believe him.