While more specific to a father the song, Fade In / Fade Out by Nothing More is amazing.

And for something a bit more visceral Hereafter by Architects. Also Death Is Not Defeat by Architects. The band was founded by twin brothers and one of them passed from skin cancer before the album those songs are on was written.