It varies greatly. Depending on how many offsets are in the pipe and how durable the cable is. A non motorized camera can inspect up to 200' of straight 4" pipe. On average the farthest I can go is about 120'.
The motorized cameras generally have 400' of cable but cannot take turns greater than 45 degrees.