I showed a friend once how bitrate and sampling frequency start to really matter when doing stuff like slowing down a lot. But I guess it's not typical in DJing.
I generally record everything in 44khz, but I will record at 192khz if I know I will be doing any time stretching. The high sampling frequency matters for that.