I've tried playing hotseat games vs myself as well as hotseat vs myself and AI. Unfortunately, my games have always ended prematurely from gradually losing interest.
What I really want is to get to the most interesting part of the game, the late game, in which the tactical aspect opens up with new unit types: multiple naval units, air units, tanks, and missiles. But getting to that era takes too long.
What I'm most looking forward to from the experience is better use of military units, and world wars among multiple civs.
To help me roleplay, I use Info Addict mod for guidance. In one of the windows, it lists the diplomatic pros and cons of how each civ feels about the currently selected civ, exactly equivalent to seeing how an AI opponent feels about you.
I cannot be 100% sure about this, but I've made a certain observation. It seems to me that the game seem to group up certain civilizations game after game in the same groups. So for example, warmongering civilizations are grouped together, peaceful civs are grouped together, civs with their unique units in the same or close eras are grouped together. Hard to get some action on a continent with all peaceful civs.