Stay here. Stop looking. This is the place. The location is right next to the bus stops for the Dublin Express going to and from the airport. It is right across from the Temple Bar District and loads of other sites/areas.
Phil can tell you all about local hole-in-the-walls and great places to go that won't break your bank like The Temple Bar might.
The room was cozy, yet sleek and modern. It was perfect for my fiancée and I, and we will definitely stay here again if we ever make our way back to Dublin.