Not sure you'll hear much difference on a record, since so many factors come into play; you really just have to play some to understand how they affect your playing, but there are quite a few famous ones; "Mississippi Queen," by Leslie West is often referred to as typical of the P-90 sound with an overdriven amp. "Live at Leeds" by The Who featured a P-90 SG Special; Santana at Woodstock in '69; Rolling Stones Get Yer Ya Yas Out, I think Keef played an SG Special.
Here's a video with Greg Koch, my apologies for the Gibson:
Santana at Woodstock:
And last but not least...me! I played a P-90 guitar on a TON of ads in the 90s and 2000s. But I can't remember which ones. So there's that.