My experience has been similar, but somewhat different than others. On my system, in my room, all SACDs do not sound the same. Some sound a little better than standard "Red book" CDs, others sound significantly better.
The best sounding SACDs in my collection, in no particular order are:
Dire Straits
Steely Dan
Depeche Mode
Mannheim Steamroller
Duran Duran
The Police
Supertramp
Michael Jackson
Cat Stevens
James Taylor
Chris Isaak
Mike Oldfield Tubular Bells
Pretty much any jazz or classical release
I'm sure there are others in my collection, but I can't recall them...
Anyhoo, you're pretty much guaranteed to get better sound with any SACD, from a fairly small difference, to an OMG difference, compared to the standard CD.

