I was thinking of the motherboard header as well, but I've never used it(sleep mode, etc..), so I'm not exactly sure how it works.
But if it does trigger when the PC goes into sleep, then I'd use an optoisolator connected to a transistor that drives a relay that turns off the neons.
