My current Time Machine drive is a 4TB HDD I've been using for...probably like a decade at this point. It's been very reliable. But being an HDD, it has the obvious downsides of noise and slowness.
Using a NAS as a Time Machine target is also convenient in the same was as storing files on the NAS. My MacBook will continue ...