for NON planted tanks, no more than 1.5 inches of gravel should be used. 3/4-1" is best.
in planted tanks, up to 3 inches is best. ideally, the substrate should be sloped and about 3" in the back and slope down to 1.5" in the front. this is because the larger plants you would put in the back of the tank have more extensive root systems, and small foreground plants have smaller root systems. the plants roots will spread through the substrait and prevent anaerobic pockets from forming, or from mulm building up in the gravel. you still should vaccume in all the places where there are not plants, but its unesecary to vaccume the gravel where you have plants.