Yeah, I used to work in it, on it and around it. Refineries are the worse(t?) and the rigs can be oily smelling, but sewage? They may need to check the Porta-Potty.
I don't doubt you, they can be funky. But, my parents had a well across the street from their house that never smelled bad.