I was just listening to "Fragile" a couple of night ago and thinking exactly the same thing. I also listened to some King Crimson stuff - "Islands" and "Starless and Bible Black." And Premiata Forneria Marconi (PFM) - "Photos of Ghosts."
All produced when musicianship counted for something.
Like you, I never really tried seeking out modern stuff like this. Is anyone writing and producing music like this today? Good question...
Thanks for reminding me about "The Yes Album." Another one to add to my must-buy list :-)