Depends on the size of your garage, too. An 80 gallon monster in a suburban two car garage doesn’t cut it.
I did fine with a 20 gallon belt driven horizontal, tucked under a workbench for thirty years. Now that I have the room, a five hp 80 gallon is more practical.
A lot of the new oilless compressors are very quiet now. They run at lower speeds than the old noisemakers, and are worth considering for home use.
I picked up a two stage, 26 gallon Kobalt fro Lowe’s. It won’t paint a car, but will run air tools.
Also, consider that air tools have largely been replaced be battery operated tools. They are quieter, and perform well. That could impact your decision as to what is best for you