As long as I'm still me, but linked, then yes, being a part of something greater is what almost all of us want

I think we'll eventually have a partial hive mind, effectively the internet now, but linked through cybernetics to our minds, allowing us to be individuals inside the collective, which imo is the best outcome, I want to be me, but with access to all of human knowledge and the ability to communicate with anyone else on a whim. This setup could also help with our tendencies to be selfish and inconsiderate, hopefully. Also given enough time, I would also expect consciousness uploading or transfer, which would be getting even closer to a true hivemind, which idk about, again, I want to be me, not a drone, but still linked to humanity