Good rules of thumb:
- Av or Aperture priority for landscape/portrait photos
- Tv or shutter speed priority for action/sport shots
- Unless you print on a billboard scale or are pro, you don't need high level SLRs with whatever grand amount of mega pixles.
- Don't sacrifice too much shutter speed. Better to pump up the ISO and use noise removal software.