A guideline is higher end workflows should use ProRes HQ. If you would normally edit uncompressed then go with ProRes HQ. If you would normally trancode to DVCPROHD or you just wished you could edit uncompressed then use ProRes SQ. I would always go ProRes SQ skip HQ unless your targeting film release and shooting on a higher end camera like Red,Varicam, F950, Genesis, etc.