File transfer over USB cable option no longer appears after upgrade to MIUI 10
Though I was pretty sure I'd transferred files with at least one of the USB cables I tried around the time I posted this question, I tried a third cable at work tonight and the file transfer option now appeared!

So unless it was a coincidence, it seems it was due to a USB cable that was designed only for charging and lacked the wiring for file transfers!