Sting
Bono
Larry Mullen, Jr.
Harry Connick, Jr. (not a rock star, but he is hot)
Paul McCartney circa 1960's
I can't think of anyone else.
I watched an old Sex & the City on Friday, and John Bon Jovi was Carrie's flavor of the week. I don't think that I ever read the Amycat My Rock Star Fantasy story. Do you have a link?