The worst case here is "software bug at 2AM means that you have to use the staffed entrance".
Obviously, it's relatively recent that we got 24/7 service back, but I'm not counting the COVID service reductions.
I dunno what the regs say, or what the MTA publicizes, but the reality is almost any station in Brooklyn, Queens, Harlem, etc. is going to be unsupervised in the late hours. Maybe there’s somebody lurking in an annex somewhere, but the ticket/info booth will be locked up and no MTA personnel, not even a janitor, will be visible. This was even the case for heavily trafficked stops like Bedford or Lorimer on the L.
I live in Brooklyn Heights and used to routinely work until 2 in the morning; there was always someone in the booth a High St. and Clark St. at that hour.