This game doesn't have nearly enough agency, in my opinion, to be considerer a fully fledged power fantasy. Sends you down a power trip every now and then, sure. But if just as many times, or near enough, any hold i might have over my character is yanked away from me because some writer needs them for their OC to shine, then i'd say we're not talking about Dragon Age: Origins for sure. More like Final Fantasy or something.
Like, sure, we're playing the hero, but most of the time we're also merely going down the beaten path, or railroad more like since major choices that don't strictly involve sex mostly split between worthless ones (Garth's family quest) and unilateral ones (Option A for access to the orc tribe/Option B for fuck all).
Again, maybe a power trip here and there, but i struggle to call this a power fantasy when i'm not even allowed to choose wether or not my character should invite Cait the turboslut, also a groomer in training, to his kid's batpism
Also please Brienne stop asking for advice to that cat every time you get pregnant, jesus h christ