I also know some sad people in quest of immortality, but they were generally sad before they found out about that stuff. In general, I think that seeking immortality has surprisingly little effect on your prior personality. It's just something you do if you have enough of a logical frame of mind to think "Life is good, death is bad, and Voldemort isn't a real person", but the logical mind is the cause, not the effect.