Not normally, no. Although I have seen achievements award stuff like character upgrades on the xbox console main screen.
Im not certain, but the sword "blight blood" may be achievement related...or is that always awarded after completing the Dragon Age Origins: Awakening dlc?
Mainly tho, achievements offer minor goals with atleast some form of recognition. It may not be much, but I find it enjoyable to do a second play through while placing emphasis on getting certain achievements.