As a musician I can only recommend my favorite albums, specific for instruments.
Solo piano: McCoy Tyner, "Naima", from "Echoes of a Friend".
Drums, bass with either flute or sax: Elvin Jones, "Agape Love".
I found these in the late 1960s and no other music has risen to their occasion.
I have one symphonic rock suggestion, "Gates of Delirium" by Yes, from "Relayer",
their only album with Patrick Moraz playing keyboards and producing.
I have to include King Crimson and their "Court of the Crimson King".
As far as female vocals, I could talk about Heart, but I'd lose it.