Opulence and extravagance are in the emirate’s DNA, but not all the city’s hotels are dipped in gold. Here are my choices.