I used to even enjoy night dives in Texas lakes... Lake Travis, Canyon Lake, even some of the rivers were fun. But I would always rather be in the water, than out of it.
Not much color... but since the bottom was not kicked up by a bunch of diver, viz was always better... and you would see stuff you would never notice / see during the day. There used to be a lot of freshwater Prawns in the San Marcos river that were fun to see, but I understand they are much more rare today. Canyon Lake on the Dam side... the bottom is covered with an old pecan grove... it can be a great dive, but you need to treat it as an overhead environment... and be very careful not to kick up silt. Great night dive for advanced divers. Travis Lake.. especially in the winter.. crystalline at night... with some walls in some areas that go fairly deep. Big Catfish in the Dam area... just be careful where you dive in that area. (This was all twenty five years ago plus... so what it is like now, I don't know.)