Sign of life!
I thought I'd give it one more chance, so I disconnected the Lightscribe sata cable, gave everything a gentle wipe, reconnected it all and it all seems OK. The drive has now stopped flashing and its reappeared in the Device Manager, which reports that its "working properly"...