This article is from the SF references in music List FAQ, by Rich Kulawiec rsk@gsp.org with numerous contributions by others.
The Rah Band:
Had a mid-80's hit single, "Clouds Across the Moon" which is about a
woman taking a phonecall from her husband working on Mars,
the phonecall is cut off by interference by the clouds of the title,
before she can say how much she loves him.
Red Hot Chili Peppers:
"Subway to Venus" from "Mother's Milk".
Renaissance:
"Jekyll and Hyde" from "Azure D'Or", and "Kalynda (A Magical Isle)".
"Faeries (Living at the Bottom of the Garden)" from the eminently
forgettable "Camera Camera" album. And, of course "Scheherezade",
an entire LP side's worth of it. Highly recommended if for
no other reason than Annie Haslam, an operatically-trained singer
with incredible range and power.
Replacements:
"Androgynous" off "Let it Be" discusses "unisex evolution" and how
"Dick and Janes" who wear pants and skirts will be future outcasts.
Return to Forever:
Fusion jazz with Chick Corea, Al DiMeola & Stanley Clarke.
"Romantic Warrior" is a medieval/fantasy concept album. Tracks include
"The Sorceress" and "The Duel of the Jester and the Tyrant".
Return to Forever's "Where Have I Known You Before" is Scientology
(a weird religion invented by the late SF writer L. Ron Hubbard) set
to kick-ass jazz-rock fusion music. It's all instrumental, but the
pieces are linked with titles taken from a poem about some kind of
quest through space. Fusion fans should also check out "Hymn of
the Seventh Galaxy".
Revolting Cocks
"We Shall Cleanse the World" from the album "Big Sexyland" is based
on, and contains samples from the movie "The Omega Man." "Attack
Ships on Fire" is on the same album, but the only SF connection seems
to be the title (Rutger Hauer quote from "Blade Runner.")
Rezzilos:
See "2000 AD", and "Flying Saucer Attack" from "Can't Stand the Rezzilos".
REM:
Single "Superman", which is actually a cover of a super-obscure 60s
psychedelic tune by The Clique. For extra SF value, the beginning of
the track is the sound produced by a talking Godzilla doll. "7 Chinese
Bros" on "Reckoning" is based on an old children's book called 5 Chinese
Brothers about 5 brothers with magical powers. Also, in general, the
"Fables of the Reconstruction" album has a strong dose of Southern-fried
fantasy, especially in songs like "Wendell Gee".
Radiorama:
This Italian pop/disco group released an album entitled "2nd Album",
which contains ongs like "Aliens" (inspired by the movie), "Yeti"
and "Vampire".
Rainbow:
Heavy Metal. Some fantasy tracks, e.g. "Temple of the King",
"16th century greensleeves", "Kill the King", "Stargazer".
See the album "Rainbow Rising". See also Deep Purple.
Ramases:
"Space Hymns", including great fold-out cover, studiowork by
Godley & Creme; apparently expounds religious visions of infinite
regress of microscopic universes.
 
Continue to: