While bigger apertures theoretically offer better resolution and brightness, Earth's atmosphere often limits their real-world performance. Turbulence and air currents cause "seeing" issues that blur images.
In urban or suburban areas, light pollution and heat distortions mean very large telescopes may not show much improvement over medium-sized ones. High-altitude locations with stable, dry air allow larger apertures to shine.
For backyard astronomers, moderate apertures around 6 to 10 inches often provide the best balance between capability and atmospheric limits.