is doorman still supported? it doesnt look like any significant changes have been made in the last 4 yearrs?

Not really, no. The original creator has moved on and the other solutions have out-paced Doorman. I’d recommend Kolide Fleet, which is also free & open-source but has a whole company supporting it.

That's what I thought, it's the same with SGT as well.

osctrl is another option, fully open-source and it supports file carving, which Fleet unfortunately does not

I haven't delved too much into file carving, so I don't know what that gives me

Extraction of files/directories from machines that are running osquery

for fim?

that is different, you can enable that via configuration though, this is actually extracting the contents of files/directories

for what purposes though?

investigations, checking logs or configuration files