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.