Yes. I've always splurged on nice cards for my personal stuff. I think it's more about the write behavior of Linux than anything else, since I've never had a card die in my camera.
I refuse to use a pi with SD at this point. Saving $50 isn't worth my time to reinstall things.
I couldn't count the number of failed sd cards I've seen across all my fingers and toes.
I've seen like 4 ssds in my entire life fail. Plus you could just do mdraid 1 / btrfs across 2 of them if you want
Why not just connect an ssd via USB and save yourself the hassle and torment?
My understanding is the media and projectors are heavily tied together with strict DRM. This is why you see cams with direct audio hookups, but not direct video rips
Mikrotik is big in the small isp space, they should be solid.
Mine is all sfp+ and I just use 1g/10g base-t sfps where I need copper.
My only complaint is the cli is horrible. I'm used to Cisco gear and mikrotik just made no sense to me.
Check out mikrotik. I recently got their crs309 and it seems solid.
Their cli is horrible though. It does get warm but I have it in a location that can hit 40c and it's been stable.
You can get 1gb or 10g base-t sfps, or they have other models with various port configs.
I don't think there is anything else free. Best you can do is host with someone like ovh that has enough resources to provide basic protection.
What's your budget?
The internet was designed to route around failure. Taking down an isp upstream wouldn't generally impact internal routing, or routing between them if they're peering.
I haven't actually setup vlans on mine yet so can't help there.
All my sfps worked without messing with autoneg though.