Don't overlook that the Contax G2 has a easy to use manual focus dial on the face of the body. The G1 has a manual override but it is awkward in my opinion, I never use it on my G1. I might add that the G1 and G2 autofocus works extremely well and I think after some experience with it you may learn to like it a lot.

If you are looking for a simple, reliable manual SLR like that in your description I would look at some nice older bodies along the lines of the F2, F3, RTS, F1, OM-T. All of those cameras are terrific and there are others as well.