Good Old Games have recently made the Heroes Chronicles games available for purchase once again. Each chapter of these standalone single-player scenarios built on the Heroes of Might and Magic III engine focus heavily on storytelling and on 2-3 factions at a time. Some people in the community loved the stories of Tarnum, others hated the games for their limited features. From the GOG site:

"Follow the steps of Tarnum, a barbarian who, upon hearing from a bard about a tale that barbarians were once ruled the continent of Antagarich, unites the savage tribes and wages war on everyone. This renegade has to serve the ancient Ancestors (the Barbarian gods) to redeem his soul in order to be permitted into the Paradise, the barbarian Valhalla.
Visit a plethora of places ranging from barren caves to lush jungles over the course of hundreds of centuries and several worlds. In the Elemental Plane, subjugate the Elemental Lords that want to conquer the real world. In the Underworld, deal with various powerful demons to retrieve a heroes soul--and more! Guide Tarnum through an epic story of struggle, success, defeat, and redemption..."

I personally really enjoyed the Tarnum stories, even if like many fans I found the scenarios a little too easy. Also, there is no multiplayer, hotseat or otherwise. All eight chapters are sold for $9.99.