Brendan
The Haynes manual diagrams are only for cars up to 1990. At that point Ford changed a lot of things around such as the third wire on the door microswitches, courtesy light wiring, etc.
The door switch has a good ground and I get the same result when I bypass the wire and switch completely and go directly from relay straight to ground. That's why I'm mystified because everything logical tells me it SHOULD work, but it just doesn't.