I have a Marantz SA-8001, which was a highly-rated SACD player that came out around 2006. I also have the aforementioned Music Hall turntable, going in to a C4S'ed Seduction.
On this setup, there certainly are recordings that I prefer on LP, while others sound much better on CD/SACD. For example, a mint-condition, stereo copy of John Coltrane's Giant Steps sounds much more open and detailed than the remastered CD version (containing out-takes) played over the Marantz. However, when I digitized that LP (96/24) and burned the files to a CD (44.1/16), the CD I mastered sounds just as good through the Marantz as playing back the actual LP on the turntable. On the other hand, a mint copy of Rush's Moving Pictures sounds far worse on LP than an older CD pressing (pre-remaster) through the Marantz. Also, any SACD I own tends to sound as good as my vinyl setup, without the pops, crackles, and decreasing treble towards the inner part of the platter.
I have concluded that much of the difference in sound between the two instruments on my rack is probably due to differences in mastering versus attributes of a particular format or device. Vinyl's pleasing qualities are easily replicated when digitizing an LP and playing it back through the Marantz, so the vinyl is either mastered better than its commercial CD cousin, or is adding euphonic distortion to the signal that is not present in the commercial CD pressings. SACD's also tend to have much attention paid to them during the mastering stage, so it's difficult to say whether the better sound is due to the delta-sigma "DSD" encoding or the fact that somebody actually paid attention to the audio before slapping it onto a disc. In my opinion, a lot of older vinyl albums sound "better" than the later CD versions for that same reason - the margin of error for mastering is far smaller on vinyl than it is on CD, which is why it's common to get a nicer-sounding, less compressed version of a new recording on LP and a brickwalled, "loudness war" version on CD. Metallica's 2008 album is such an example. The tonearm would literally leap out of the grooves if somebody tried to master an LP that way!
I'm just old enough to have bought my first albums as records, so I think that may factor into why I've held onto my vinyl setup. However, if everything were offered on carefully-mastered SACD's, I'm not sure I would bother. The fragility, limited play time, surface noise, and finickiness of vinyl can be frustrating, which is why in the past 5 or so years I've tended to digitize and archive any new LP acquisitions and listen to the high-res digital copy on a DAC, or burn a 44k version to a CD. All the things I liked about the record are still there, with the benefit of the record staying in great condition on my shelf.
