Sorry for the delay, summer got in the way!
I modified a soft rubber CCS charge port cover, and glued a betalight into it. Took a bit of trial and error, as the charge port cover closes to within a couple of mm of the surround to the connectors, and the Type 2 connector lower edge projects down into the space between the CCS pins. The betalight I used was one intended for use with night fishing floats, and works OK, but could do with being a bit brighter. When I plugged in this evening after coming home from the pub, it was pitch dark outside, and the betalight did provide a reference point, but it doesn't really light up the Type 2 connector at all.
Ideally, a light fitted under the charge port cover might be best, but there's very little clearance between the inside face of the cover and the face it closes down to, certainly less than the 3mm diameter of the betalights I have.