In other media for sure, but that hasn't really been the trend in Bioware games or video games in general, I think.
I can't even think of that many RP games where I can make meaningful choices that indicate my character is a gay male.
Besides, some people really like drama, and might enjoy such a romance.
That's why I said I'm happy for it as a choice. I would not want that to be the only way the romance ends. I have no doubt that some folks would enjoy that. Solas' romance could be considered pretty tragic and he's still popular. I just wouldn't want that choice forced upon a gay/bisexual KISA.
It would be nice for a change to have the chance of a happy ending for a gay couple. Dorian was a great start, but I think the DA team could do better. Their track record hasn't been very stellar. Heck, just look at the NPC list of gay/lesbian romances:
Marjorline/Leliana: Abusive relationship, taken up to new heights by the end of the Leliana's Song DLC
Branka/Hespith: Hespith tainted, feverish, after watching her lover turn her House into darkspawn
Anders/Karl: We remember what happened there.
Wade/Harren: Had to be confirmed as a gay couple. Not to mention that they largely came off to me as a couple where the love died years ago but YMMV.
Anders/Male Hawke could also count, given what Anders does in the game. I find the "crazy bisexual" trope a tad old, but that's neither here nor there at the moment.
I've noticed that there isn't a lot of gay couples that are alive in Inquisition. We're usually finding a ring, a body or a letter that we have to take back to the unknowing widow(er).
I have no problem with a tragic romance. I just would not want that to be the only option for a gay/bisexual KISA archetype LI. That's all. 