I have done some stories, on occasion, with people turning into objects–usually underwear–but I tend to shy away from those themes more generally. For one thing, inanimate TFs aren’t really my favorite ideas–I use them, but usually not as a end goal. Also, its really hard to generate conflict and a good story around an inanimate TF, because it removes all agency from the character being transformed. The story, then, has no capacity for any sort of push and pull between antagonist and protagonist, because one character is now completely powerless by definition.
As for finality and death…I don’t really find death to be particularly erotic–or I should say, I don’t find the death of a body to be particularly erotic. I mean, most of the characters in my stories do die, at least so far as their non-physical identity is concerned. They emerge on the other side of the story as someone entirely different in most cases: new motivations, new desires, new bodies, new memories, etc. You can call it a torturous limbo if you want, but those characters are people too–they have as much inherent worth and value as the people they were before. But more than that, death is lazy writing. Stories don’t really end, the author just stops paying attention to them. There is no real finality in these stories, and that’s the point. I suppose you could say I prefer to leave up to the reader’s imagination, but I’m by no means expecting the reader to keep doing the work, imagining a story beyond what I’ve written for them. In each case, the story I wanted to tell has reached its conclusion. There’s a new status quo beyond, but that’s a set up for a different story, not the one that’s finished.