Don’t applications running under your user account have access to your user’s home folder by default?

The entire point of macOS's TCC was supposed to be to make that not the case anymore.

No. You get prompted something like “Application wants access to your Documents folder” and “Application wants access to your Downloads folder” on first attempt of each folder.