When you invest the time and energy with the right people, it can be enormously fun and deeply satisfying.
However, much of the time, not so much. Finding the right band situation isn't easy. One or more things won't click -- often out of your control -- and you have to make the tough choice to stick it out, or move on.
Are work situations so different? Not from my perspective.
When it all works and works well, teams in the workplace can be huge fun and deeply satisfying. Other times you have to decide whether to slog through it, and hope for the good stuff down the road apiece.
And if the magic doesn't materialize, sometimes the wise decision is to politely move on and set up shop elsewhere.