I am in a union in Germany and the main result is that I earn considerably less the market rate.
This is because there is a single pay grade for every Software Engineer in the company(excluding entry level). There are no performance bonuses. Unless I get promoted into management I can look forward to the union negotiating a slightly above inflation pay rise every so often until I reach retirement.
It's a lot to swap for the workplace protections that Software engineers mostly enjoy anyway.