The crazy thing about the Borg is people would absolutely sign up for assimilation if it were consensual. The perfect peace and tranquility of abandoning your self to a vast collective, having your entire civilization archived, essential posthuman eternal life (depending on whether the "Borg" really exist as data, just using drones as necessary physical interfaces, which is my own headcanon but I don't think actual canon.) People would absolutely give up individuality for that.

For a species with vast collective intelligence and access to data on countless cultures, they seem to have the worst possible approach to their goals. They assimilate by nanoprobes, after all - they could easily create replicants that resemble a target species and have them blend in, slowly spreading a dormant "infection" that doesn't trigger until it's spread through enough of the population. Just throwing cubes at anything with a heat signature works in a brute force way, but there are more elegant methods.

A more aesthetically pleasing, subtle Borg as a foil to the Federation would be interesting. It frustrates me how a lot of new Trek has been sort of teasing at plot points involving AGI and synthetic life and cybernetics but they never really dive into any of it.