Here are the RPG games I can remember enough from my playthroughs to rank their tedium for back and forth, and provide rationale/criteria.
From most tedious to least…
The Witcher - has limited area map with a few fast travel predefined locations, slow transitions between areas, very limited personal inventory, unlimited and omnipresent storage boxes, quests require a lot of back and forth, need money for best armor
POR 2 - no fast travel, fast transitions between areas, no storage boxes (can use NPCs for this if careful), quests require more back and forth, unecessary to sell extra loot (nothing to buy, so just drop it)
POR 1, COtAB, SotSB, PoD, IWD 1 & 2 - No storage boxes, has limited area map with a few fast travel predefined locations, no travel spells, limited personal inventory.
NWN 1 - No area map travel, no travel spells, no storage boxes, limited personal inventory.
BG 2, NWN 2 - Has storage boxes, has limited area map with fast travel to a few predefined locations, no travel spells, limited personal inventory.
BG 1, FO 1 and 2 - Has storage boxes, has area map with fast travel to predefined locations, no travel spells, limited personal inventory.
Gothic 2 - Teleport runes to specific locations, no storage boxes yet mitigated by unlimited personal inventory, quests require back and forth.
DD 1 - No area map travel, mark and recall teleport pyramids, somewhat limited inventory, infinite storage almost anywhere on the ground.
Daggerfall - Has extensive area map with many fast travel predefined locations, has mark and recall spells, has storage locations, has cart to carry lots of loot.
Morrowind - No area map travel, has mark and recall spells, has temple teleport spells, has fast travel via boat, silt strider, mage guild, or propylon indices, has storage locations, limited personal inventory.
Might and Magic 4 and 5 - No area map travel, has lloyd's beacon spells, has town portal spells, has mirror portals, has teleport spells, has fast travel via boat, no storage, limited personal inventory, super fast movement and transitions.
Fallout 3, Oblivion - has storage boxes, has huge area map with many fast travel predefined locations, limited personal inventory.
Others I've played, too, but I can't remember enough of their back and forth quotient to comment, but I think this is enough to understand my complaint with The Witcher.
Note, I am purposely leaving out action RPGS like Diablo which usually have a TON of back forth, but it's usually designed to be very fast.