It's not a file explorer so not exactly what you're looking for, but WizTree is good for finding out which folder contains the large files. It's like WinDirStat but much faster.
Thanks, I’m familiar with WizTree but to the best of knowledge it’s meant more to find what’s taking space, rather than navigating between folders. I’m not sure how practical it would be as a replacement of file explorer, for example I think it defaults to mapping out the whole drive (rather than a specific folder). But thanks anyway for the suggestion!
if you start from File Explorer Navigation Pane and used the default WizTree install then every folder (in File Explorer) should have a right click context menu item that launches Wiztree for just the folder subtree.
if you start from command.com or Powershell then you can pass a subdirectory path as an argument (with a switchy? I don't recall ATM) or make a shortcut comman to launch WizTree for a subfolder.