This website can save you a lot of hunting.
http://skyteam.com/about/travelhelp/travelinfo.html
Holding a Canadian PR visa can indeed get you into a lot of countries (visa at the border) that were formerly denied (you needed a consular visa). The immediate border visas are not always as long as a Canadian citizen would get, but certainly adequate for a holiday. Example: I get an automatic 90-day visa into Costa Rica, but my PR wife would get only 30 days.
However, having a Canadian PR doesn't always make a difference. It seems PRs still need a consular visa to visit (or transit through) the USA. Same with Panama.
So, if you're visiting the Caribbean, avoid the USA.
Use the website for preliminary research, then confirm with the embassy of that country to be sure. Better to take that last step than arrive at the border only to find the website was wrong, and you cannot enter after all. And as a final precaution, take whatever emails you get from the embassy to the airport with you, in case the airline employee doesn't want to let you on the plane without a consular visa (the airline is reponsible if you must be returrned to Canada where the border officer denies you entry to the destination country).