Yeah, it felt like a bit of a dumb suggestion for someone in your position. Might work for someone with a less..robust level of need? Works for me with a QNAP QSW-2104-2T (this doesn't meet your criteria fwiw, unmanaged, not sfp+ but there is an sfp+ version that's still unmanaged) does that really matter if you have a pfsense box?
Edit: QSW-2104-2S is the double sfp+ version.
Er...Asus RE-BE88 technically meets that criteria but that's a router...I think it even does the VLAN stuff?
https://forums.truenas.com/t/the-future-of-electric-eel-and-apps/5409
I'm not the best person to explain the how or why but they are looking at Q3 for beta and Q4 for main release.
I'm running Immich, Nextcloud and Jellyfin on TNS and it's fine. Nextcloud takes a bit of work though.
TrueNAS Scale will have Docker in the next release in August, along with the ability to expand Vdevs.
Probably not that helpful but Truenas Scale and the Nextcloud App, and then just used the Collabora "plugin" as I gave up using a separate Collabora App because I couldn't make them work together. Probably going to have to fix everything again in August when the next TNS update drops (Electric Eel) and enables vDev extensions.
TrueNAS scale, LIS HBA cards, server motherboards with plenty of PCI Lanes ie AMD EPYC, large capacity HDD, just make sure they are CMR and not SMR drives. And Raidz2 is your friend. You will not need 40 drives, frankly you will fit 10,000 films, mostly 4K and 1000 complete TV series on a single 12 drive wide Raidz2 vDev using 20TB drives. That's enough to last 50 years in terms of viewing time.
Thank you for explaining, as that's really helpful for my own learning