My family and I stayed at the Drury Inn for a quick "before school starts." The Drury was priced great for our stay and close to the sites. Since we had kids (2, 6, & 13) with us, we didn't do the night life, but the Drury was close to all the family attraction too. (But if you are going for adult fun, it is close to that also). The St. Charles Streetcar was right outside the door and we were a short walk from the Children's Museum and the Aquarium.
The only bad think I can say about this Inn is that the parking is offsite (but they are building a new parking garage) and if you don't call down for your car, it could take a while to get it. The parking was $25, which is cheaper than most hotels I have stayed at in downtown NOLA.
The breakfast was great and the evening "dinner" was a great pocket saver. The kids had fun eating in the lobby. The free drinks that were offered the the adults was a real treat. The staff was wonderful and very helpful. The room was clean and well maintained. I didn't smell anything like some of the other reviews say. The beds were very comfortable but are really soft. I tend to like harder beds, but it was not so bad that I couldn't sleep.