Well, not all of them, obviously. Yet, for example, I tend to think Joe Biden actually did have good intentions considering the bulk of the PATRIOT Act was based on his prior legislation in the 90s, his Omnibus Counterterrorism Act. It's worth noting this was in response to a wave of US homegrown right-wing white nationalist radicalism and terrorism in the 1990's such as Waco and Ruby Ridge. The Oklahoma City Bombing would happen a month after this bill first appeared. Considering the shitstorm we're in regarding virulent white nationalist terrorism, I kind of think back when he first wrote it that it wasn't such a bad idea.
People who were more clearly war hawks like Hillary Clinton? Probably a lot less likely to have had great intentions.
Yet others, like Ron Wyden, who has been a consistent critic of the out of control national security state and voted against military intervention in Iraq in 2002 also voted for the PATRIOT Act. He also spent a great deal of time trying to amend the PATRIOT Act as well.
And as much as Democrats drink from the same well of corporate funding as Republicans, I wouldn't say the majority of the party is outright evil or don't care what happens to their constituents. Schumer obviously doesn't give a fuck, but I also don't think he's actually representative of the party as a whole as much as he just has power in a party that puts seniority over merit in intraparty politics.
It's easy to forget how much shock and terror 9/11 really did put into people which colored how quickly they foolishly signed off on the PATRIOT Act.