So SCFM, or standard cubic feet per minute, is the volume of air at standard temperature and pressure your air tools require, or the compressor can compress.
At the outlet of your tank, the air will be regulated down to 90 PSI. Your tank itself will be at either 115 or 155 or whatever PSI its designed to stay at. As long as your tank is above 90 psi, you'll always see 90 psi air in your hose, and at your tools (minus pressure loss due to hose length, fittings, etc, but thats minimal most of the time). Period. End of story. Your compressor will not under-power any tool, if you have 90 PSI at your hose.
Now, for the more complicated explanation-
When you use an air ratchet, or a die grinder that pulls 7-9, or more SCFM, you're going to deplete the 155 or 115 psi air in the tank faster than your pump can replenish it. Your compressor will kick on when the pressure in the tank reaches 120 psi (or whatever the set point is) and will run until the tank charges back up to its pressure. Its at this point that your risk dropping below 90psi (if you're using more air than you can compress) and decreasing the output of your tool.
None of this matters occasionally. Your compressor and motor will have a duty cycle. 10 minutes on every 30 or something like that. You'll use your tools, and everything will cycle on and off, charge and discharge, and then you'll drain the condensation out of your tank when your done, and that's it. A 26-30 gal compressor has enough storage capacity at 155 psi to run anything moderately. Just being mindful of your duty cycle is the most important thing. Most 110 V compressors are sealed, and oil-less. If they're used too much they overheat and fail. So when you're running your air ratchet, give your compressor a break to stay within its duty cycle, and it will be just fine.
Like everyone else said, painting, sand-blasting, etc, these things all basically vent 90psi directly to atmospheric pressure, so you drain your tank very quickly. Doing these things, you risk exceeding the duty cycle of your compressor and overheating it if you don't watch the time your compressor runs.