I appreciate Demme as a filmmaker. But, I feel his whole career led up to Silence of the Lambs. He gave everything he had (to amazing effect), but didn't seem to have much left over. Every feature he has done since has been to diminishing returns. He has this campy sensibility I love throughout his work, which I'm sure he tried to understandably temper for Philadelphia, but it still managed to unconsciously find its way in, to inappropriate effect.
And, the film gets too maudlin for me at times. I know that for some gays who are older than myself, this film holds a special place in their hearts for good reason. But, even at that young age I was in the 90s, I had a ton of admiration rather for Longtime Companion. I just think Philadelphia wasn't my bag, and Demme wasn't the best choice for the material.
I believe he did the movie in part because he felt guilty for some of the characters infuriating people at the time. There were LGBT protests (for another classic, Basic Instinct, as well). I never really got them. I understand people were angry about "representation" of queer people in movies and there weren't enough "strong" and "admirable" examples at the time. But, I honestly don't think people walked out of Lambs thinking gays were evil people, and if they did (they were fucked up themselves). Technically, Hannibal was straight (perhaps bi), but his primary interests were in Clarice for reasons that may or may not have extended to underlining sexual desires (he suggested there weren't, but I never believed that). And Buffalo Bill was a gay man. I don't believe he was trans, as it's LITERALLY explained in the movie that he wasn't. Between Hannibal and Buffalo Bill, I really didn't see a problem. They kind of "balanced" each other out. And FFS, Clarice was a low-key lesbian hero (even though it isn't explicit). But Demme caught a lot of flack for that, which is part of why I think he did Philadelphia and directed it in such an earnest manner (ironically, as mentioned, void of any sexuality; although I will say Hanks looked hot, lol).
Or maybe I couldn't relate to Beckett like OP. When I was younger, I still related to straight characters more like the junkies in Trainspotting (not their drug habits, just their attitude and ironic views on life, unfortunately) or Veronica in Heathers (lol). Or H.I. McDonough in Raising Arizona--a guy for some reason who couldn't get out of his own way as he tries to imitate the more traditional paths in life and failing miserably.
As far as gay movies, A Beautiful Thing came out around the time that I would have bene part of the target demographic, but it never really stuck with me. I guess I would go back to Longtime Companion. One of the reasons why I loved it was because Dermot Mulroney is unapologetically femme in that film (but not way on the extreme end of the flame scale--not that there's anything wrong with that). I hadn't seen that before. I suppose I saw myself in him in that way.