IMO, the answer is: it depends. For example, for amplifiers, it is very important to know the power level that the SNR is measured relative to. (This is why Stereophile's measurements are not directly comparable to Benchmark's specs.) Most manufacturers like Benchmark, including ATI incidentally, quote SNRs for amplifiers relative to rated power output, while John Atkinson (and Gene) measure SNR relative to one watt. I dislike SNR measurements referenced to rated power, for a lot of reasons, not the least of which is that it's a marketing trick for producing a higher number as a figure of merit, just like A-weighting does, but it's worse because every amp has different gain and rated power, and because amps typically don't run at rated power. That's why one watt unweighted SNRs for amps make the most sense - because one watt is a realistic power level for actual use, and every amp is measured at the same level.
Noise, unlike distortion, is mostly a constant value regardless of output, and most absolute measurements I've seen are in microvolts, and IMO are best plotted in a microvolt scale across a frequency spectrum. That's cumbersome, so broad-spectrum unweighted SNRs are the convenient figure of merit.
So, for unweighted 1W SNRs, -75db is a very good measurement. I think about -97db is the best I've ever seen (not that I've looked much lately). I've seen amps with measurements as low as -57db. Is there an audible difference between amps at -57db, -75db, and -97db? Maybe. It might depend on the speakers.
If you use very sensitive speakers, let's say 95db/2.83v/1meter, since noise is mostly a constant in the amp, and sensitive speakers need much less output, in this case 10-12db less power than a typical speaker, it is possible that a better noise spec could make an audible difference in quiet passages. I have to admit I doubt it even at -57db, but I'd bet $100 that at -75db it was never more audible than -97db. Would I rather own the -97db@1W amp? Absolutely. Is such a low noise spec audible? I really doubt it, especially with more typical speakers.