Excellent question that merits some investigation.
Too bad I did not try OTG when I had my tablet; that's something I'll have to look into later when I get the replacement.

I will say with the nexus 7 and LineageOS I have had a recurring problem with USB OTG becoming unresponsive when using flash drives despite the service for charging and USB keyboard always works. No idea what it is and being a non-GNU Linux I am not sure how to track down the issue. the problem crops up and can persist for months sometimes if I am lucky fixing itself for a bit if I reflash to certain saves. The issue even presents itself in the TWRP recovery manager. Not sure if this a hardware or software issue but worth considering.
Of course this is a major problem because the MTP connection is super wonky.
Franky it is tricky getting data on and off of Android based devices, not sure if that is by design. But on the N900 be it a flash card, USB, USB host mode, wifi, or bluetooth the transfer is sweet and easy unlike Android.
(edit)
OK, today was hardware day...
I tweaked my slightly bent Nexus USB port, now it works, but it turns out that my little OTG adapter is NOT working . So not software or something inherent in the design of the Nexus, with the springy teeth the charge and keyboard cables/jacks worked fooling me.
I also got Amaze file manager going, it has an FTP server included. Cant get it working secure but for a few minutes of online at home annon login is enough to tweak or backup files from my laptop.
I bet the loose port is what was making my MTP connection so flaky too.
I will say that unlike the N900 the Nexus7's USB port is anchored down quite well and just took some bending with a screwdriver tip to get it OK.

I finally bought a second hand Nexus 7 with LTE in real good condition (no visible marks of any usage, don't know how the guy kept it in that condition), for about 130 EUR.

Flashed Lineage OS on it, configured users profiles and installed some apps... I must say, from an "entertainment" device point of view it is quite good. Don't get me wrong, for ssh or mail (or any other security/productive activity) I will still use my N900, but for lets say online videos, tv channels, music etc. I could use the tablet.

I only have one little thing that is bothering me : how to get weather working on the tablet. No good results when it looks for "cyanogenmodweatherprovider" on F-Droid or Google Play.

you need
indiegogo.com
iggcdn.com
stripe.com

I also allowed session cookie for indiegogo.com and www.indiegogo.com

I'm thinking of getting the Xiaomi Mi Mix. It has a 6.4 inch screen. Not quite a tablet but close. Apparently Lineage OS is available for it. I'm looking into it. Assuming it is working well, would someone provide a link that shows how to port Sailfish on a device that is running Lineage. Thanks! .

Replying to myself.

Here at the bottom :

Weather Providers
YahooWeatherProvider.apk
OpenWeatherMapWeatherProvider.apk
WundergroundWeatherProvider.apk