Confession: In my first playthrough as a male warden in DA:O i found the way the story ended extremely rewarding for my character: my PC gets to live, has a baby with his true love and runs away with her through the eluvian. When I first played as a female I was shocked to find that whatever path I chose my wardens story would end tragically. Since then I always play a female character, desperately seeking my happy ending.
Perhaps you were playing it wrong then?
The ending I got, as a human female, I married Alistair and we ruled together with him as King, Morrigan got her God baby, everyone but Loghain survived and they all lived happily ever after…