I actually encountered a 4TB git repo. After pulling all the binary shit out of it the repo was actually 200MB. Anything that promotes treating git like a filesystem is a bad idea in my opinion.
The git userspace would need to be able to easily:
1. Not grab all files
2. Got grab the whole version history
... and that's more-or-less it. At that point, it'd do great with large files.