Theories on why "Sue," "Susie," etc. is such a popular name for lyrics

Bingo

May is also a good one for rhymes, but it hasn't been a popular name since probably before WWI

Jane doesn't end in a vowel, but is a pretty good rhyme name

 

Mary Jane seems to be held in high regard too...

 

Sue who do you blew?

 

I am duly corrected. Only knew the Steppenwolf version and was too lazy to look up the writing credits before I posted.

 

It's easily rhymeable.
Ergo,...

 

Many many rock groups and singers sourced their material from R&B and soul records, groups, singers, etc.
I recommend "the Atlantic Rhythm and Blues" box set as a great introduction to this music and artists.
Individual collections by Wilson Pickett, Otis Redding, James Brown, Aretha Franklin, Solomon Burke, etc. will
often have the original versions covered by mainstream rock acts.
Also I recommend anthologies of the King, Vee Jay, Stax, Hi record labels among others...
Motown also, of course.

 

Not to mention that "Mary Lou" gets the same rhyming-benefits as "Sue".

 

Goodbye Mary Sue
Who knew you’d make me blue
Hello Peggy Blue
How do you do?

 

One time I counted if I love more songs with Sue or with Diane. Results:
Sue (3) -"Runaround Sue" by Dion; "Crocodile Rock" by Elton John; "A Boy Named Sue" by Johnny Cash
Diane (3)- "Diana" by Paul Anka; "Oh Diane" by Fleetwood Mac; "Jack and Diane" by John Mellencamp

(HM to Roxanne/Rosanna - with two songs that I love - by The Police and Toto)

 

Nick Lowe

I got seven nights to rock
I got seven nights to roll
Seven nights, I'm gonna have a whirl
Seven nights with a different girl
Seven nights to rock
I got seven nights to roll
Monday, at sister Suzy's ball
Tuesday, at the old dance hall
Wednesday, at the road house inn
Thursday, at the lion's den
Friday, at the chatter box
Saturday and Sunday, everybody rocks
Seven nights to rock
I got seven nights to roll
Seven nights, I'm gonna have a whirl
Seven nights with a different girl
Seven nights to rock
I got seven nights to roll
I got seven nights to rock
I got seven nights to roll
I got seven nights, I'm gonna show my face
With a different chick and in a different place
Seven nights to rock
Seven nights to roll
Monday, I'm gonna rock with Jane
Tuesday, it's gonna be Lorraine
Wednesday, I'm taking Nancy Lee
Thursday, it's Betty Lou and me
Friday, I'm gonna jive with Sue
Saturday and Sunday, any chick will do
Seven nights to rock
I got seven nights to roll
Seven nights, I'm gonna show my face
With a different chick and in a different place
Seven nights to rock
I got seven nights to roll

 

Leonard Cohen would like to add Suzanne.

 

You left off the rest:

And on the 8th night
I’ll be chillin
With Penni Sillin