A believe people in the US are so Anti-Union because the way Unions are designed by law is completely broken.
I remember well that we once had a booth at a trade show in Las Vegas. It was strictly forbidden for us to take our exhibits to our booths ourselves, because the process of "take something onto the exhibition floors" was union-protected. So we had to wait half an hour to get a task done that would have taken myself 30 seconds.
I believe that unions are needed, and am strictly pro-Union.
I believe that Unions serve the goal of being a counter-weight when a huge employer has lots of negotiation power.
But what I have seen in the US - and to a certain extend in Germany, too - is that certain UNIONS have grown to big, powerful and bureaucratic, and have become a huge force of power themselves, no longer serving the workers, but being self-serving mostly, and bringing employers to the brink of collapse.
In Germany we have two competing unions for rail workers. One is huge, corrupt and self-serving, and no where connected to the actual pain points rail workers have. But luckily there is second, much smaller rail Union, where the Union boss used to be a train driver and still is very much in touch of the base, and therefore does not pick fights with employers "because they can", but to actually work on pain points the workers have. Which is really important because Germany has a huge shortage on rail workers, and urgently needs to attract new labor in that sector. It's a bit weird that the rail companies are not working on fixing the shortages in labor, and the government isn't either, but that it's a union that is fighting for making life of the customers bearable again.
Back to the US: I believe the whole discussion of being pro-Union or pro-free-market is a red herring. The unions themselves need to be reformed and strengthened, but in a way that they serve society. In general I believe unions should be smaller and leaner organizations.