have you tried Assaha restuarant? they have the best apple sheesha ever. Or try the cocktail sheesha at the terrace cafe at Sharq resort. A bit strong and pricey, but SO good! Ras Al Nasaa (the castle restaurant at the corniche) has good sheesha but their service is crap!