In all of my playthroughs of DA:O I've had [url=http://www.youtube.com/watch?v=ZODMaH7R3Es]this playing at the bridge in Bownomar.
In life, I like anything with a good beat for work. To get me in 'in the mood' nothing works better than jazz or soul. Jazz is pretty much the language of seduction. Anything is fine for just background noise, as long as it doesn't have vile language. For just listening to, classical, light opera/musicals or live jazz. Live jazz is about as good as it gets. For fighting off the blues, country or r&b are the go-to choices.