picture "painting by numbers", draw a sine wave - which one will be more precise, the one that gives you 44 points (the standard - creative is known to upsample to 48 and then convert to 44.1 in playback) to connect or the one that gives you 192 points to connect?

this is only half-true, as nyquist also states that a sampled sine wave at the nyquist frequency (i.e. a 24-kHz signal sampled at 48 kHz) will be perfectly reproduced as exactly the same sine wave on playback, even if the samples don't "look" like a sine wave any more. this is also true for any sine wave below the nyquist frequency. this is because reproduction isn't done as "straight lines between the sampled data points", but rather using the more real life sinc function.

any deviations from the sine wave in the sampled signal which cannot be reproduced after sampling due to too low sampling rate will be part of signals higher than the nyquist frequency, and therefore inaudible anyway. this is why those higher sampling frequencies are useless.

however this is all only true if there is a good low-pass filter in front of the sampling ADC, otherwise you'll get aliasing effects. so, higher sampling rates can help if the low-pass filter is either not good enough or simply missing. this should only be the case with low-end soundcards though.

this is all in theory of course

in reality signals at the nyquist frequency might not be reproduced perfectly, but since the limit of human hearing is somewhere at 16-18 kHz and the nyquist frequency at 44.1 kHz is at 22 kHz, there is plenty of headroom.

and as you mention resampling: nyquist also states that conversions between sample rates are "lossless", as long as the same low-pass filter as mentioned above is used and also the sinc function is used.