Well, Death: The Time of Your Life is probably the best of them. Or at least, it’s the one that I got the GLAAD Media Award for Outstanding Comic Book for. You’ll like Hazel and Foxglove, I hope; although the impetus is that Foxglove is a closeted rock performer (based loosely on people I knew in the ‘90s) and I hope the culture has changed enough to push that into the past. (I’m not actually certain if it’s available on its own now, or only in The Death Deluxe Edition: https://amzn.to/31F3U6w)
There are LGBT+ characters all the way through Sandman, and you’ll also find queer and LGBT+ characters, most of whom have happy endings, in American Gods, Coraline, and Neverwhere. (Murder Mysteries, a short story and graphic novel,adapted by the amazing P. Craig Russell, has some angelic lovemaking in it, although they are technically angels, not humans.)