YA? Book involving trans sex worker and 1920s movie star - "Southern Discomfort"?

I remember getting this book from the YA section of my local library in high school, so around 2001-2004, and I've tried googling for it many times over the years but not found anything.

I even think I remember the title being something like Southern Comfort or maybe Southern Discomfort, and the hardback having magnolia flowers on the cover. Both of those potential titles are pretty common phrases and make it hard to google.

Here's what I remember about the plot:

• there were at least two storylines which weren't really connected to each other that I can recall
• one of these storylines was about a silent film star (a man, I think) at the beginning of the sound era of film who was struggling to adjust to "talking pictures" because his voice wasn't appealing to audiences
• that storyline leads me to think the entire book was set in the 1920s
• the other storyline was about two women who were sex workers living together and, over time, developed into a romance between the two of them while both were still doing sex work
• the last thing I remember is at the end of the book, one of the two sex workers died, and an autopsy uncovered that she had secretly been a transwoman, which even her lover had not known in all the time they were together

Parts of this book have haunted my brain for 20 years so I would love to find it and read it again!