We all only get to experience our single life. But to have opportunity to have memories and experience many more just sounds enticing to me. Borg isn't mindless. It is a collective where ones arguments don't need to be debated because you can reach better consensus because you can fully experience and understand the counterpoint and why views differ. We are all blind to our own anecdotal experiences.
Exactly. General symmetry breakup process guarantees that uniformity in highly interconnected environment wouldn't be a stable state, ie. it means the necessary emergence of non-uniformity, basically individuality, at different scales - personal, group/team, cube, ... It is just that such individuality would look different as it will be driven by emerging non-uniformity instead of just physical barriers of our skulls.
what is wrong with the Borg? I mean emotionally we all dislike it, yes. Yet speaking objectively, the Borg is the naturally highest state of developed life we can conceive off. Atoms makes molecules like proteins, lipids, etc., the molecules make cells, cells make organisms, organisms make society... The same cycles of assembly/integration and specialization, basically the same 2nd law driving life at different scales. Looking at the level of integration and specialization our society has so far reached i'd say it is just the level of primitive multi-cell organisms. The Borg is the natural state of society when the level of integration and specialization increases, and increasing of that level is just the 2nd law gradient in application to the live systems. Resisting it is just like insisting on staying "free" single cells instead of combining into organisms. The organisms would see the stars, the cells - no.