I'm not sure, but I think you go where you believe you belong.
So someone who appears to be a good person, but is living a double life and secretly fears they'll headed for someplace bad, will end up there.
If you truely believe there's nothing once you die, then that's what you get.
So yes, if you believe you'll go to the Caribbean when you die, that's where you'll be.