I suddenly remembered this manga in the shower but can't remember its name. I may be misremembering some part of this intro as it has been a while since I read this.
It starts when the main character (MC) dies and gets to see his own funeral as a ghost. Then gods show up and tell him that he can wish for anything, so the MC asks if they can make it so the people at his funeral forget about him. The gods come to like him because of his selflessness, so they reincarnate him into another world with his memories, as per his request in the answer he gave, where only he remembers them, so it makes the pain of his death only go to him.