This actually looks pretty good. Dragon Age was a game I would consider upgrading my PC for, but the couch is looking pretty inviting at the moment. There's so much story and dialogue, reportedly, that I'd rather be lying down with a controller than a keyboard/mouse, I suspect. There's also the extreme length of the game. I find that I can more easily handle long games with a controller (damn you, RSI!).
I suppose the graphics will take a hit, but judging from the video, it still looks very nice. At least it seems that they really optimized the interface for consoles and all the gameplay seems to be the same. I'll be interested to hear from console players on this site when it comes out.
