Welcome. A big question with a multi-part answer is, what do you want out of a dive trip? I've got 4 dives in St. Thomas with Admiralty Dive Center (they did very well with me), none in the Great Lakes. That said, I don't think anyone will challenge the assertion those are very different places to dive. For some examples of what I'm talking about, consider...
1.) Some people are big on lush, underwater 'flower garden' coral reef diving in 'bath water' conditions (tropical, often low current), and some pretty tropical fish. the Caymans (e.g.: Little Cayman's Blood Way Wall and Jackson Bight area), the outer atolls of Belize (such as via live-aboard) and the diving I saw off southern Roatan with CocoView Resort would serve that purpose well. So would some of the more southern west coast dive sites of Bonaire, which is popular with shore divers.
2.) Some people like the above, but enjoy shore diving. Bonaire is the regional mainstay of this, but Curacao is really good if you need sandy beaches and a larger island with more topside civilized entertainments.
3.) Some like good reef, a nice mix of tropical creatures, overall budget trip costs, a variety of good, often cheap food topside and don't mind drift diving...Cozumel!
4.) Some people like diving with big animals - Goliath grouper and sharks out of Jupiter, FL, the off-shore wrecks with sand tiger sharks out of North Carolina, tiger and lemon sharks out of Tiger Beach at Grand Bahama, a mix of creatures in the Galapagos and Socorro, etc...
5.) Some people love cave diving.
6.) Some love history, the 'real' wrecks vs. those placed as artificial reefs, and places like the Great Lakes, South Carolina or Truk Lagoon have special appeal.
Some people just take dive trips to dive. Some want topside amenities like a luxury hotel or 'authentic' encounters with foreign locals, or excursions (e.g.: jungle tours, zip lining), shopping, etc... Some are taking a non-diving spouse or kids. If you tell us more about what you're looking for in a dive trip, we may be able to suggest some places.