I bought a QNAP about 10 years ago and then replaced it about 4/5 years ago with another more powerful QNAP TS-451. It is still running strong and keeping up with my needs. I don't know Synology at all but have read comments here where some prefer it over QNAP. Know @vsman has several videos on QNAP on his YouTube channel so he might have some input here too. I am likely a light user of my NAS as they seem to be meant for small businesses.
I originally bought one to have backups of my multiple PCs in a RAID configuration. I also ran a mail server since at the time Mindspring/Earthlink only allowed me to have 100MB storage in my inbox
and I needed somewhere to offload emails and attachments. I also owned a Logitech Squeezebox and I ran the server component on the NAS as well since I had a large music library. With streaming services these days I don't listen to as much music on my NAS as I did years ago but it is all still accessible.
Once I upgraded to my current NAS, Virtual Station (ability to run VMs) and Container Station (ability to run docker containers) came out and I have since leveraged those features. I have docker containers running NodeRed, Grafana, InfluxDB, HomeBridge, and EchoSpeaks. The NAS also has MySQL/MariaDB running so I use NodeRed to offload events and logs from my HE hubs into a database for longer term storage. The NAS also has video streaming capabilities. Via AppleTV I can access my video library on my NAS to stream to my TV.
I personally have enjoyed owning one. I believe it has been well worth the investment for me but of course like any computer you will be replacing hard drives from time to time and that adds up. But I typically buy them during Prime or Black Friday sale events.
All of this said, QNAP and Synology have a similar feature set to run everything I describe above so you won't go wrong with either vendor.