Does anyone know of similar books such as "they both die at the end"

Now that you mention it, the only such story I can think of on short notice, apart from an obvious classic, is Matrix Revolutions. There must be others, but it's so, so unusual.