The best location is really a subjective term. What do you plan on doing during your trip? will you have a car? are you into a young hip hotel? (if yes, check out the W on Poydras, there are tons of reviews on this hotel in the Starwood Forum in FT Miles). Or are you looking for a classic old hotel away from the hustle and bustle of Bourbon Street? (If yes you should check out the Garden District and Uptown.)
I live in New Orleans and probably have an opinion on most hotels in the city. My parents (in their 50's) love to stay at the Fairmont when they want a weekend getaway. It has classic charm and is usually a short cab ride to where ever you want to go.
Having a car is also big determination in where you want to stay. NOLA does not have any reliable public transportaion. The buses are old and dirty and the street cars are usually more for entertainment rather than an aid in getting around town.
More info please
------------------
Rachel
CO - Platinum
Hilton - Diamond
SPG - Platinum
The Princess' Pictures