i did not mean check for a loose connection where the sensor bolts in, but where it plugs in on the other end. that wiring harness is mounted to the engine and gets a lot of vibrations, chances are good that there is a loose connection there.
Ah, I see what you're saying. But we replaced that sensor. You're saying that a) the previous sensor may not have been bad, and b) it may just be a loose connection?
I tried to wiggle the sensor, and it wiggled only a tiny bit, but not enough to make me think it is losing electrical contact. Maybe it is, though. How would I tell???
I also tried to wiggle the connectors (there are two, it seems??? Which is kinda odd, since there is only one sensor...) on what I presume is the DME--that long, black box running along/partially underneath the engine block (?). They wiggled substantially.
I wanted to try disconnecting the connectors on the DME and see if that would replicate the problem every time. If so, well folks, we have our answer.

But alas, I didn't want to break anything so I didn't pull too hard to get 'em out. There might be a bolt or something I'm not seeing.
BTW, my car was running perfect in the neighborhood until it got fully warmed up. Then, as I was making a right-hand turn at a stop sign up an incline, and pressed the gas rather hard, the CEL flashed and the engine misfired, but DID NOT stall. When it came back to idle, it rumbled and came too a low idle, then went back up to normal idle speed.
I can replicate the CEL/misfire almost every time as follows:
1) Idle, fully warmed-up engine (must be at idle). I have
not tried this test with a cold engine; I suppose I should. I have a feeling it will do the same thing.
2) Press gas quickly and substantially
ONCE so that revs go above 1,000 RPM but below about 2,500 RPM. A slight tap will not produce the desired effect.
3) CEL usually flashes and car usually misfires.
4) When engine comes back to idle, it goes to about 550 RPM (lower than it should), car rumbles, wants to stall or something, but catches itself virtually every time.
5) Conduct gas pedal OBDI diagnostic.
6) CEL flashes 1244, signifying "camshaft position sensor."
I have about a 60-70% "success" rate in replicating the problem with the above process.
Does it still sound like a camshaft position sensor?
out of curriosity does anyone know what makes the CEL flash a cam sensor code? where does it get its information from to decided that its a cam sensor?
This is what I want to know, too!