I have a line of 6 outlets, 1 ceiling light and 1 outside light on a switch. Everything is not working EXCEPT, get this... the last outlet on the line. How in the hell can this happen?? 20amp Breaker is fine, never tripped. I reset it and no change.

Open the last receptacle and the one right before it. Check connections at both receptacles, one of the blacks or the whites is failing to maintain a good connection. Check back stab connection, frequently the source of issue like this.

Burnt wire, disconnected wire, broken wire. Check with a voltage tester.