I really want to get a dog, but I see how their passing affects people, and not sure I want to go through that. Is it worth it?

yes get a dog. They do die, and it does suck but all the love and happiness and the fact you gave them a good home for years is worth the pain of their eventual passing.