Just have a look at what was passed today:
> Article 17/9: Where rightholders request to have access to their specific works or other subject matter disabled or those works or other subject matter removed, they shall duly justify the reasons for their requests. Complaints submitted under the mechanism provided for in the first subparagraph shall be processed without undue delay, and decisions to disable access to or remove uploaded content shall be subject to human review. Member States shall also ensure that out-of-court redress mechanisms are available for the settlement of disputes. Such mechanisms shall enable disputes to be settled impartially and shall not deprive the user of the legal protection afforded by national law, without prejudice to the rights of users to have recourse to efficient judicial remedies. In particular, Member States shall ensure that users have access to a court or another relevant judicial authority to assert the use of an exception or limitation to copyright and related rights.
So this also encourages to appeal in court against the current very opaque content upload policies. Certainly this is not strictly better than the current situation (where you can be arbitrarily banned), but definitely progress compared to the situation today, where platforms just act like they see fit.
> Article 17/7: The cooperation between online content-sharing service providers and rightholders shall not result in the prevention of the availability of works or other subject matter uploaded by users, which do not infringe copyright and related rights, including where such works or other subject matter are covered by an exception or limitation.
So overblocking will be costly as well, if enough suitable laws are signed into effect and people start complaining. And this really puts large scale commercial (remember non-profits are exempt) sites in a though spot: they either share revenue with content-creators/their organisations (which are mostly s*, but could be changed...) or they employ even more moderators (remember the small paragraph, where banning is to be done by humans ;)) – which all severly limits the current exploitation of the internet as a big chunk of empty space, where the strongest strongman is going to grab the biggest slice and employs an army of user-slaves.
> Article 17/10: For the purpose of the stakeholder dialogues, users' organisations shall have access to adequate information from online content-sharing service providers on the functioning of their practices with regard to paragraph 4.
I guess already today a lot of people would like to know, how Content-ID blocks their content, but Google can't and won't say (because it will show their dirty secrets...).
=> IMO: all in all, for the average person, the internet might develop back to where it was 20 years ago with select content-providers and quite a large proportion of actual people hosting fun stuff (and moderating their own boards...). If people are as IT-literate as they claim to be (although I doubt that for the large percentage of fortnite-playing #saveyourinternet-people) we might as well enter a real golden age of the internet.