"But the US founding fathers saw this situation: Someone with 'standing' brings a legal case, and eventually the case makes it to the Supreme Court of the US"
Thomas Jefferson opposed the creation of the supreme court in Marbury vs. Madison. Madison was his secretary of state.
Here is his reasoning:
"You seem to consider the judges as the ultimate arbiters of all constitutional questions; a very dangerous doctrine indeed, and one which would place us under the despotism of an oligarchy. Our judges are as honest as other men, and not more so. They have, with others, the same passions for party, for power, and the privilege of their corps.... Their power [is] the more dangerous as they are in office for life, and not responsible, as the other functionaries are, to the elective control. The Constitution has erected no such single tribunal, knowing that to whatever hands confided, with the corruptions of time and party, its members would become despots. It has more wisely made all the departments co-equal and co-sovereign within themselves"
It's difficult to consider the counter-factual of the court not being created and common law having been continued, but it's useful to understand that there was opposition, and why, so that if you support it, you can use this knowledge to make it better.
In more modern times, partisanship does seem to be a problem, with many of the most important decisions are made 5-4 on party lines.
As you have brought up, another problem is that, contrarily, that it may be that the supreme court isn't actually not be powerful enough. If the U.S. is using the U.K. to spy on Americans, isn't that a blatant end-run around the constitution? But where can standing be, if legal opinions are based on secret courts, and gag orders are imposed on everything?
At the same time, it's not "Just the supreme court's" job to uphold the Constitution. Ultimately, it's the people's, and our most direct representatives are the House. They take an oath to uphold the responsibility, and they can't simply subcontract it, it doesn't work that way.