In October, I redeemed some Delta miles for a couple of nights at Pop Century. At the time I booked, there were 2 different mileage levels for standard rooms. It appears that one was driven off the rack rate and the other was driven off a public room-only discount. It wasn't the best use of miles, but it's getting tougher for me to find good flight redemption levels with my Skymiles so I didn't mind using them for the hotel.
Leslie, with Delta it's a "use miles" option off their Skymiles pages.