In an era when Top 40 embraced rock music, these artists surprisingly never achieved a pop hit in America, including many Rock Hall members