4L6e intermittent Transmission Issues
When the line pressure is high enough 3rd gear will engage, otherwise not. Perhaps when you are shifting manually you are giving more throttle which raises the line pressure.
Frank's test may succeed because disconnecting the harness forces max line pressure, but then not tell you much. If it fails, we know the trans is toast.
Most likely it will need a careful and complete rebuild from someone like Frank.











