I went on a glass bottom boat in Jamaica. It was not a spectacular boat, just a small one with a glass bottom.
It was cool though, 'cause we were able to see everything below clearly fishes, reefs etc..
It was in Negril but you can probably find glass bottom boats all over the Caribbean.