Straight guy here. I don't really bring my real life preferences into gaming as I'd rather create an interesting character than simply play as a version of myself. I'm all about 'what works for the story' not 'what works for me'.
I've played a gay Dalish elf who was... more than friends with Tamlen and later hooked up with Zevran as rather crappy attempt to get over his survivor guilt and eventually commits suicide by archdemon. I've played as a straight male Cousland playboy who'd even make a play at Wynne if the dialogue would let him. He happily OGBs Morrigan and walks away with no regrets. I've played Skyrim as a female Nord warrior called Freyja who found Roggi Knot-Beard a charming oaf and in the end, married him.
I pretty much played the entire ME trilogy as Femshep because I felt Jen Hale sold the character better than Mark Meer did in the first game. I avoided the romances for the first two games because I played her as someone who wouldn't violate the chain of command by bedding a subordinate, but did eventually cave in and romance Traynor in 3. That was mainly through a combination of it being a real doomsday scenario and the fact that, by that stage, Shep has the whole weight of the galaxy on her shoulders and I felt she really needed someone to lean on.
Traynor also won by dint of her not being part of the ground team and the fact that she and my FemShep really clicked as opposites attract. It just made complete sense for both the story and characters at that point, in a way it hadn't earlier in the trilogy. That it ultimately made Shep a bi in a lesbian relationship was more an outcome of her experiences and personality than a predetermined choice I'd made when I first drew her up... and totally not where I'd expected it to go four years earlier.
I guess Shep could've gone that route with Kelly Chambers but didn't because I didn't play Shepard as someone who was into casual sex, which makes her complete opposite of my female Hawke, who is a snarky amoral rogue, so wrapped up in protecting her baby sister from the Templars, she'll never commit to any serious relationships that could compromise her ability to up sticks at a moments notice... and so scratches her itch at the Rose... or occasionally with Isabella.
My male Hawke, OTOH pretty quickly committed to Merril and stuff anyone who has a problem with elves, (even though I personally hated the dizzy-cute stereotype they made Merril into in DA2).
As for Inquisition, I've played through with a fairly straight laced female Circle Mage who has a thing for Cullen but took forever to work up the courage to let him know. I've enjoyed the hell out of it.
They've all been great stories that I've thoroughly enjoyed playing and my own personality or preferences have never featured prominently in any of them.