The Earth First faction would totally gaslight everyone about the existence of the Borg.
The Borg?! Ha! Yet another radical leftist Federation boogeyman! I'll bet credits to navy beans that it's just an excuse to expand Starfleet and take away your phasers! Wolf 359 was an inside job! But in case you do get infected with nanoprobes be sure to buy my Ivermectin^TM brand purity pills, only 4 bars of Gold Pressed Latinum!
In my headcanon, the Borg eventually reach a truce with the Federation, and over time eventually become full-fledged members of the Federation. That's CRAZY right?...Is it? I mean, the Federation warred with the Klingons and Romulans, and look how those relationships changed over time.
How about the Borg's willingness to join? What we've been seeing over the years is that the Borg adapt. Their willingness to adapt had been established from their very introduction as a faceless hive-mind. Over the course of the franchise, they've experimented with individuality with Locutus, Borg Queens, becoming so infatuated with individuality that they even dispatched 7 of 9 to live amongst Starfleet to investigate directly, and then instead of efficiently assimilating her to gain her knowledge, they choose not to re-assimilate her so that they could ask her about that experience and avoid corrupting that knowledge via assimilation. Why is the Borg so interested? The Borg found that Federation individuality had repeatedly repelled Borg invasions when Borg calculations indicated that they should have won, and even after re-adjusting for past failures, the Borg still found themselves stymied in encounters with Starfleet. The Borg were even saved from total extinction by the ingenuity of individual creativity and a temporary alliance with a Starfleet ship. That is a huge motivator for the Borg to re-assess their approach and look for a new way to adapt to prevent their vulnerability to a similar event in the future.
Would the Federation be open to it? Like I said, they've allied with past enemies before. Ex-Borg members of Voyager served with distinction. Borg tech has proven invaluable to Voyager's return. Most importantly, Borg Drones are not undead zombies! Assimilation is a reversible condition, and that means that instead of hating the Borg for killing their loved ones, the Borg ARE their loved ones. Moreover, Borg assimilation is a weapon of mass diplomacy. Chakotay found that the hive-mind allowed warring alpha-quadrant races to all live in harmony in the Delta Quadrant, and losing access to the hive-mind allowed their old destructive conflicts to creep back in, and ultimately they reinstated a local hive-mind to regain peace. Chakotay joined that hivemind and came away from it with unparalleled understanding and empathy for the other members of the collective, and an overall positive experience, and he disconnected with immediate recovery and no ill-effects!
That is a game-changer, it allows the Starfleet to show up on the door of a new alien race, and those aliens would naturally be cautious, suspicious, mistrustful of the Federation's intentions. First contact is extremely dangerous. An alliance with the Borg could allow Starfleet to establish first contact by saying, "We come in peace", assimilating the alien envoy, and then the alien representatives would know that Starfleet truly and honestly means to "come in peace", casting aside all suspicion of ulterior motives. Starfleet then disconnects the alien envoy from the local hivemind, and then those envoys can go home and sing Starfleet's virtues to the rest of their race.
Modern people with tortured minds would probably be happier as Borg, but in Star Trek's time they presumably have effective treatments for it so it's not so appealing.
In other words, yes, there would be a decent chunk of volunteers.
I mean... What's wrong with assimilation other than it being forced on people?
Edit: Seriously. I'd love to see real opinions on the idea of borg assimilation, assuming that it's not forced. Obviously forcing it is evil, but what about the inherent nature of the process, what it does, and what happens to your mind?
Assimilated drones immediately lose all autonomy, and can never regain it without outside influence (which they will likely be compelled to resist). It's functionally suicide, except that your body and mind continue to be used for whatever purpose by an entity you have effectively no control over.
I understand joking about the benefits relative to the frequently unpleasant world we live in now, but I have serious concerns about anyone who would rather be a Borg drone than an ordinary 24th century Federation citizen.
I mostly question what the collective is like from the inside. The descriptions we get in the show tend to just say it's a constant cocophony of voices. To me, that implies the individual minds still exist within it, they just all share a collective voice. But at the same time, they have the queen and they kind of imply the queen directs the hive mind or at least is a manager of some kind. I'm a bit of a singularist, so some aspects of the Borg are just fascinating to me. I am fine with giving up physical autonomy to exist as just a mind in a collection of other minds; but I would still want my voice to matter and help shape the collective.
Perhaps not with the Borg, but I just don't have fears toward the merging into a collective part. The body horror is scary and really just because it looks painful as hell to be assimilated.
Or perhaps I'm just envious of Picard and Seven who got to experience something most don't. Even if it was a bad experience... I really gravitate toward experiences that are aren't real or impossible for me to have. I know I am of the time Picard lived an entire lifetime in his mind because of an alien probe. That would be dope.
“Covid 19 is back, the Zeta variant is highly transmissible, but without any real side effects. the only way to ensure humanity’s survival is to destroy it by assimilating it”
“Assimilate today, we will all be the same. No more worry about being different. Being a different race, a different gender or a different sexual preference. We will be simply Borg instead. United and as one. Resistance is futile”
“If we all assimilate, we can cut CO2 emissions by 70%! Assimilate today, save the earth”
Why did the borg go back in time to the 2060s? Why not go back in time 2023, when people are dealing with the cost of living and lack or access to basic essentials. The borg would enslave those they want to and prevent first contact.