Depends on what you're doing. For power lifting the hips just need to be below the knees. Any lower it's considered to be a waste of effort. In Olympic lifting, you need ATF to be able to catch the big weights.
As has been said, the lower you go, your hips/glute/hams are recruited more.