Scuba Point is a great dive store, with helpful employees, lots of equipment to rent, and "Goldfinger", the world's largest air compressor certified for SCUBA. When they kick it off, you can hear it underwater, or so they tell me. When I asked, the store personnel told me that it was expensive to run, so they didn't do it often or for entertainment value. I liked the inventory, environs and employees of Scuba Point very much.
However, the diving area itself can be frightening for newly-certified divers, which my roommate and I were at the time. Vis was terrible, the terrain dropped off unexpectedly, and there seemed to be a lot of pipes, cables, and rusted-out items that probably used to be attractions.
I hear that there are still good dives in Possum Kingdom Lake if you have access to a boat, which I don't. Now that the reactor is heating up the water there, and if you're like me and don't have a boat, I recommend spending the extra time in the car and going to CSSP, Lake Travis, or one of the other cleaner, clearer dive locations.