I am glad you are currently out of "emergency" status.

I do not know of a good DIY video inspection solution. (You need a very good light source also.)

Around here, it is the sewer repair guys that typically have that kind of system. Their cameras are very good to view the line from the house to the city sewer main. I think our guy had a spool that reached out to 150'.

Good luck!