I wouldn't want tragedy for anyone, male or female. I wonder why anyone would (Not that I'm against their choice. Just curious what the thrill is there. Is it like enjoying horror movies?).
To each his own, not everyone has the same tastes, and that's why it's hardly justifiable to ask removing variety with the options, no matter what we like or dislike. An angst romance or a tragic romance can be as beautiful as a very sweet romance, sometimes even more beautiful. It's simply a different story telling.
It can make you feel different strong emotions that could punch you, that could make you feel intensely the whole romance content during all the game and that is actually the point of a writer. I'd consider as a failure a romance that affected nobody, that nobody really felt, even if you could have your perfect fantasy ending, your perfect dysney romance where everything is absolutely sweet rainbows, and all. Yes a bad ending can suck, but the journey can make it worth it and sometimes, that 's all it needs.
With Morrigan for example I was satisfied in DAO, I didn't need a DLC, and I am very satisfied with the end of my relationship with her, ( I was the Prince-consort of Ferelden. ) My warden will never forget Morrigan, and the same for her, they lived a beautiful story, Morrigan will always be his true love even if he could end with Anora, and the same for Morrigan, but their relationship was the story of passion and an impossible love and I like it. Now they moved on, you don't always need " they lived together forever " in the end to appreciate strongly a relationship that happened in your life or in your story. As long as the tragedy is well done, I don't really see the issue, again if there is variety elsewhere. Thane in M2 was good to me.
I could tell you that with Josephine, I am not really satisfied personally, and I kinda wish that Solas was a female elf instead and my other option despite his ending. Josie's romance content didn't affect me at all and that's what I find terribly horrible. I'd rather feel strongly about the ending of my romance, than feeling nothing personally. I felt everything in the story of DAI for my character except his relationship with his LI. I was totally deconnected, not impressed, not excited. " Yeah, they are together in the end,... good, I don't really care actually " is my reaction. Hell, I am not even able to write a fanfiction with her, while I did gladly with Morrigan.
I felt so much the romance in DAO, that I could share easily what my warden felt with words to other people who never romanced Morrigan and disliked her, and yet loved my piece.
Despite people complaining for Solas in this thread, it's just astonishing how everyone where I go on some sites, find the Solas romance incredible, even straight males who rolled a female elf just for him and because it was tied to the story. Everyone seems positive. Bioware really succeeded to create something with this romance, and I don't think that's just because of the path, the ending counted too. The whole tragedy overall. Solas worked a bit the same way as Morrigan. People found it beautiful, people were hurt, and that strong feeling is beautiful. At least to me. This tragic romance has just been very successful.
So really, maybe you might not be able to appreciate tragic endings, or tragic romances, but there are people who can, and they have legetimate reasons to feel that way. In the end, it's a matter of perspective anyway.