for someone who's been given 6 months or less to live? 
Depends upon the intent. Most people only say or do things to make themselves feel better in situations like that.
I'd guess the person knowing how important, loved or whatever they were has some benefit but it's hard to say for sure if anything other than "Turns out the doctor was wrong" will make them feel any better.