Talented, innovative or just plain entertaining, these six-stringers of the female variety know how to get the party rolling