People can come to terms with their "imminent demise" without the use of LSD.....I don't think that there is a moral ground for giving something like that to a dying person.

Who cares what kind of mind set they have at that point?