I assume you mean that you use larger apertures (f/2.0 is large, f/8.0 is small) because you can get more light into the lens, so you get a faster shutter speed etc.
You normally stop down the lens (use a smaller aperture) if you have enough light and want to get as much as possible of the image in focus.
For DSLR's, most photographers try to buy lenses with larger apertures as well, but those are very expensive, because they must have a lot of glass inside to to cover the larger sensor of the DSLR. E.g., a 70-200/2.8 lens for a DSLR is much larger, heavier and more expensive than most compact digicams 
The smaller sensor of the P&S, however, has the negative effect that refraction starts to impact image quality at something like f/6.3 ... for that reason, most compact digicams are limited to f/8.0 as smallest aperture. Because of the different sensor size, this is roughly comparable to f/22 on a DSLR.
PS ... a 70-200/2.8 lens can be used at f/2.8, 4.0,5.6, ... 22. The 'real' limitation is the f/2.8.
Best regards,
Andy