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!
I would absolutely line up to be assimilated. I'd be guaranteed a job that mattered, I'd always be with family and friends, I'd be part of a group that was always working towards a common goal, and I'd be happy; the borg that are disconnected from the collective are clearly deeply distressed by the experience. Plus, I'd be stronger and more capable as a borg than I can even imagine right now.
As long as people are making the choice to join the collective, why is it anyone else's business?
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.
All the borg say they prefer borg at what point do we have to just listen to them and admit we are being rascist about it? In several episodes it is shown and being a pleasant experience of I recall correctly.
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?
“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.