CM4 won’t be more powerful than off the shelf solutions. RasPis are quite bad at dealing with storage. Also IMHO Synology software is a much better experience than open source alternatives. After spending months test driving NextCloud etc I went with Synology and I don’t think that alternatives will be able to catch up any time soon.