Do you take the position that there is no role / need whatsoever for a court in the United States that needs to hear confidential matters having to do with law enforcement, where to reveal it to the subject would compromise the investigation?

I think your desire to paint it as some evil government bogeyman + some philosophy that everything should be open is over simplistic and honestly a little naive in how a country needs to defend itself.

Now I am no fan of all that the FISA court has allowed. There are legitimate criticisms of how the lack of transparency has allowed some rubber stamping of investigations without good adversarial oversight.

But to fundamentally assert that such a court should not exist is a bit ridiculous.

You might as well suggest that every time before knocking down the door of a drug dealer, the drug dealer's attorney must be notified and get a chance to argue against the search warrant in front of the issuing judge, because in a couple of cases, they knocked on the wrong person's door.