Anecdotal, I know, but the only people I know that like unions are bad employees the union is overpaying and protecting.
Example: heavy equipment operators Union goes on strike for more pay ( its already prevailing wage+++), all the other unions go on strike to show “support”, in the mean time they don’t get paid. 10 guys on my friends crew went two weeks without pay. They wanted to work and had no issue with the pay rate only the operators Union did.