Hello Jason - this is definitely gardening! My garden is basically a series of holes (so much like large pots but sunk in the ground) that is basically all you can do on a bare rock island!
Succulents and cacti will suit your purposes well. They do much better with a good water occasionally rather than little and often. Good drainage in the pots and a proper substrate is essential - get
Happy Plants Happy Mix or Cactus Mix, don't use cheap cr*p from Chinese shops etc as it holds too much water and then when it eventually dries out is difficult to wet again.
Personally I steer clear of cacti having fallen foul of the spikes a few times and the ones with almost invisible fine prickles are the worst!
There is a wide range of succulents available and some of these have spectacular flowers although as with all plants they have their flowering season (and that might be while you're not here!).
Think about where you want to place them. Will they get full sun all day? will that change in Winter? will they be subject to strong winds? Armed with that knowledge take yourself to
Happy Plants and ask for their advice.
A few pics from HP taken recently:
😊
or plants like these that have thick rhizomes and therefore don't need watering often:
Good luck and let us know what you get!