ZFS is RAM hungry, plus doesn't like USB connections (like the article implied). So, I've been eyeing btrfs as a way to setup my NAS drives. Would I miss something in that setup?

ZFS is not RAM hungry. The only official memory requirements that exist specify 768MB system RAM and thats the whole OS (Solaris 9) minimum requirement. Just like any other file system ZFS will use memory if available and release it when other parts of the system need it.

https://docs.oracle.com/cd/E19253-01/819-5461/gitgn/index.ht...

Also ZFS is perfectly happy with USB connections. In fact it's the best type of FS to have if your storage is unreliable due to its self healing capabilities. Not that modern USB is unreliable nowadays and there are plenty of DAS solutions that rely on 3.x USB.