Another vote for an XA or a Rollei 35.
If those are too manual and slow, I have got excellent results with my Canon Sureshot 76 zoom. This is an automatic fixed-focus zoom point and shoot from the mid-late '90s, and it also has "flash off" and "flash on" settings, as well as a self timer. I think the lens is 38mm through 76mm. I never found it very useful for anything beyond the middle or so, as focus and shutter speed become a bigger issue there. It has no exposure controls, and it is battery dependent for everything. These are $1 to $5 cameras, but finding them is the issue. They tend to come up all the time, but probably would not do so if you were actually on the hunt for one! You get the best results in good light with a fast film, of course, because the camera gives you fast shutter speeds and deep depth of field this way. Or maybe the shutter speed is fixed after all. Who knows. I do know that it takes nice pix for a point and shoot, though. I have never tried it on a tripod, where the long focal lengths might improve in quality. I would just use a "good" camera if I was going to lug a tripod anyhow. Any point and shoot is limiting, but any camera is better than no camera, and I have definitely made some good-enough prints from this camera that I would not have got if I had not brought it along. I am sure all the big camera companies had similar models of point and shoot cameras, and, like Canon, endless variations thereupon.