I can only speak for myself, but when looking at power supply noise, I'm typically just looking at switching supplies (or combination of switching and linear post regulator.) In that case, with the majority of switching supplies operating in the 100k-1MHz region, the majority of significant noise of interest is easily viewed on a 100MHz scope.
Obviously if you've got specific requirements well above that frequency range then you've probably also got access to high performance equipment.