I want to learn more about file systems from the practical point of view so I know what to expect, how to approach them and what experience positive or negative you had / have.
I found this wikipedia's comparison but I want your hands-on views.
For now my mental list is
NTFS - for some reason TVs on USB love these and also Windows + Linux can read and write this
Ext4 - solid fs with journaling but Linux specific
Btrfs - some modern fs with snapshot capability, Linux specific
xfs - servers really like these as they are performant, Linux specific
FAT32 - limited but recognizable everywhere
exFAT - like FAT32 but less recognizable and less limited
Btrfs, for the compression and CoW. I've been using it since a couple years. It seems stable for my use. I need to fully wrap my head around how snapshots work, though.
You mentioned CoW. I’m really taking advantage of this because I have multiple Wine prefixes that have lots of duplicate data. I want to give every application it’s own prefix, and my underlying file system allows me to duplicate the blocks so the prefixes are basically free where before it’s several hundred megabytes just to make a new prefix.