Is working in a narcotics division the most roughest branch of Law Enforcement?

When I see what they do on telivision,it really looks like something I would really be inspired to do,but I hear that they don't show everything they do on tv and it can be one of the most roughest jobs. Is this true?