Suicide might be the end for that person and yes, we want to remember them as they were in life - hold on to the good memories. But unfortunately by commiting suicide they leave a legacy of pain & confusion too. For the ones left behind it's difficult to deal with the person's death as well as the questions of what you could have done to stop it. It haunts you and I say this because I saw someone commit suicide when I was 9, 17 years have gone by and I still wonder why she did it & what could have driven her to it.
As for whether or not suicide is worse than murder or if you'll be denied entrance to heaven or whatever you believe in because of it, I don't know, it's not for me to decide or judge anyway.