I would say I'm union agnostic, I'm not against them but I have about the same amount of faith that a union will improve things in a given situation as that the government will. Both are supposed to be a representation of the people, run by the people, and both are often too bogged down by bureaucracy and power seeking to actually do anything constructive. Sure there are great historical examples of unions accomplishing great things, just are there are great historical examples of governments passing landmark laws, but neither of those guarantees that these institutions will do the right thing in any future scenario.
And to the extent that I am going to put trust in one of these institutions, I'd rather choose the government. I'd rather see, for instance, healthcare given as a right to every citizen, than healthcare given to employees in just one industry. And in fact, unions have been some of the strongest opponents of medicare for all initiatives in the US in recent years. They've already negotiated good healthcare benefits for their members and they don't want everyone else who's not a member to get it too. This kind of "us vs them" incentive system doesn't appeal to me. And more fundamentally, I strongly believe that a lot of basic things (again, like healthcare, or disability insurance, or the ability to invest in a retirement account) should be much less coupled to employment than they are today, and unions are a force in the opposite direction.