If you don’t want to be called there to always it support it, go for off the shelf solution. Both qnap and Synology offer the same. When i looked half a year ago, i saw Synology as being more expensive at the time so went with ts464 qnap.
Qnap do provide a roadmap of support for older devices. So you have an idea how long they will remain supported for.
Don’t worry, if you got even a quarter as much experience as you say, your job is safe or you can find another not working for an idiotic company that would invest into ai instead of engineers, let them fail.
Anyway have a look what ai can do for you and see just how secure your job is. Pointless worry