Awakenings is somewhat interesting if you've developed a connection to the story (I loved Dragon Age) but it is nowhere near as enjoyable as the main game. Still fun and worth playing, but underwhelming on the whole. It's really fun because of the abilities you get though... I'd say it's more fun to play, but a weaker experience overall.
I haven't heard anything good about the DLC.
--
http://soundcloud.com/thundersheep/lunatic-asylum
http://soundcloud.com/thundersheep/summer-rain