There was an episode of THE TWILIGHT ZONE" (original) that dealt with exactly that. He was a criminal, died, and thought he was in heaven because he had women and endless money. He got bored pretty quickly.
The twist was he was in hell.
The twist was he was in hell.