Came to Dubai on a 4-day weekend and found this Sheraton perfect for my goals. Location was excellent: not far from Dubai airport, right on Creek with amazing views, within short walking distance of water taxi and major Metro stop (Union). Taxis come right up to door, too, of course.
You can stay in the hotel all weekend, if you like, hanging out by the pool, or catch a water taxi to the historic old souq, or go further afield to malls, etc.
This grande dame of luxury hotels in Dubai (est. 1975) is still in great condition, on prime real estate, and close to heart of city. It offers great rates for families and weekend tourists - unbelievable value. Staff was extremely helpful. Would definitely stay again.