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.
The article seems to be saying that is true unless you implicitly and somewhat invisibly grant access via the file picker.
Not always though. Adobe’s apps seem to be able to do whatever fuck they want whenever they want. I want so badly to stop them from creating a bunch of bullshit files in my Documents folder but there simply is no way to do it.