For Dubai I'd go for a Hilton Dubai Creek Exec plus room. Floor to ceiling windows looking across the creek towards the Emirates towers and onwards to Jumeirah and the Burj and the same view from the roof pool.
Got pics lying around somewhere if you want them emailing.