Hello there, welcome
A bit of a clarification here before I get to your question. Tokyo is exclusive to the Steam version of the game, which in itself is a Global port. To make content availability a bit clearer, assuming my memory is correct:
- SP mods (ie Revival, Lost London, Nagahaku, etc) typically offer the base game and assets (with modifications, of course) alongside Stonehenge assets like Moloch. Some should also offer new quests and new enemy grades, like Nagahaku did, or Abyss assets, like Revival does.
- London 2038 offers Stonehenge and Abyss as standalone content (ie maps, enemies, and gear), alongside custom content like the Australia dungeon and new items (using existing, if sometimes unreleased, assets to do so). It also comes with more skill modifications than most other versions, leaning more heavily into the skillgroup system.
- Steam offers a very modified version of the base game, as it is essentially SP Global. It comes with a different version of Abyss, alongside Tokyo and other peripheral content (like the collaged Second Attack expansion and Tokyo's Base Defense). It also comes with new systems, like weapon upgrades being enchantments instead of level upgrades, and items related to them.
So with that in mind, your question was
what's the better single player experience?
My answer would be, the ones that best cater to an SP experience. London 2038 does try to balance SP and MP, but is primarily designed around MP - so any SP port will reflect that, unless it's also modified to facilitate better solo play. Steam is also a rather unmodified SP port of an MP game, so it too shouldn't offer the best SP-minded experience. Revival, on the other hand, is always designed around solo play (like all SP mods are) - so it should be the best for the role.
This does somewhat depend on your (additional) modifications of choice, mind you. A 2038 or Steam mod that specifically irons out the MP edges for a solo player might make either version better for this role. All 3 also have their own unique content and modifications that may appeal to different players, perhaps enough so to overlook other shortcomings or SP-unfriendliness.
TL;DR between those two choices, and specifically for a single player experience, I'd go for Revival. But it's rather subjective, and each game version and mod may have something valuable of its own to offer.