Don't get too hung up on the big numbers, 24/192 should sound better than 24/96, but comparing 192 & 96 with the same album its hard to tell.
Also comparing CD rips to some 24-bit recordings is another thing to get confused with, some are remasters, some are not, & in some cases a big 24-bit number is no guarantee its a remaster or sounds better.
Remasters do invariably sound better, but its a personal choice on what better is; the raw original maybe the making of the feel of an album & a remaster might knock off the rawness so its lost its appeal.
You mention one of my favourites that has got better with a remaster, Bob Marley's "Legend"; the 2nd track is the famous live recording of "No Woman No Cry", on the CD is a mess, a poor recording on an otherwise good album. The Tuff Gong remaster in 24/96 brings the track into life, its a real wish I was there music event, a real live band & crowd feel.
Another favourite is one mentioned by ChrisH, Forcione & Sabina - "Meet Me In London". The difference between the original CD & te high def remaster is huge, but much of that is remastering, not the high def.
Another nice 24/192 recording is Norah Jones "Come Away With Me" if you like her smooth jazz style.
One of the Eric Clapton's .... a fav 24/192 for me is "461 Ocean Boulevard"
Have you heard DSD yet, simple small group native studio recordings in DSD are stunning. David Elias "Crossing" is an outstanding example.
Finally HDTracks are the top of the expensive range, Qobuz are invariably more competive, also try HighResAudio who often beat Qobuz