I believe DVD and film are at 48, while CD is 44.1, but as noted there is not much difference. Many sample libraries are at 44.1, but certainly not all. (some are even at 96, from what I hear).
I used to use 44.1, and was quite happy with it, as it didn't tax my system (24-bit), but I recently switched to 48k, to match a friend of mine's sample rate. (his interface defaults to 48k).
As noted above, using 24-bit is where you will see a difference, over 16-bit.
Bob Bone