I've been in "leadership" many times.
I'm not really sure I like it though. I like bringing in new ideas and coordinating things to get the plan done... One big qualm I have is in controlling/supervising people, I find that very tedious. I also don't like managing interpersonal conflict.
I find that the leadership position is a rather ungrateful one, as when everything goes well, it's thanks to the team, and when things go wrong its yours. I'd rather just generate ideas and make the plan, then let someone else manage all the rest.
So would I make a good leader - yes if I wanted to I would. Would I like to be a leader - no thanks.