It seems I overlooked a quite simple explanation. Using the Files app Internal storage is hidden by default.

I've noticed it a few times using some apps but since all of my devices are legacy devices I'm not used to using SAF and having to select show Internal storage.

That's my excuse and I'm sticking to it...