Rooftop Patio in Paradise!?...any advice?

Looking for the smartest way to finish a rooftop patio so it doesnt leak but is also nice looking....
we are debating between the rolled waterproof sheets that look kinda like the material of asphalt shingles...or painting on a waterproof tar looking or ruberized liquid and then laying tiles on top. we prefer the idea of tiles as they would look better than the asphalt looking membrane. Does anyone have any experience with these options> Which works better...looks better? Long shot here!

There is a product called Redguard. It is available in Mexico. ONE AND DONE, until you need new tiles.

Lots of research can be done online with this product. The only thing I would add is, get some grade going to the roof. In other words, not 100% flat. Ponding water is a killer of everything. Not sure the size of your space but a 2% grade should do it!