A thread growing on SB over the past year has addressed the issue of why people dive in quarries, lakes and mud holes, in the first place. You might want to use the Search function and read some of the posts. Quarries take some getting used to. I did my OW check-outs in Ft. Lauderdale, didn't dive for several months, and then went to a quarry in VA (where vis is actually quite good by quarry standards). I wore a LOT of neoprene, to deal with the water temp, and I felt claustrophobic to say the least, particularly with a heavy hood. I simply could not descend - between my buddy and I we had not brought enough weight - until I picked up a couple of rocks from the bottom to stuff in my BC pockets. By the end of the day I was so frustrated that I never wanted to dive again, in a quarry or in the ocean! Fortunately, I got over it.Soundtracklover:OH...and the hood wasn't THAT tight. It was just really uncomfortable and I have never worn one. And by the time I put my hood on I was so frustrated that everything bugged me.
I echo several of the comments about wetsuits. A custom fit exposure suit, wetsuit or drysuit, is absolutely one of the best investments you can make! A DS is somewhat costly. A custom fit wetsuit, while not inexpensive, is much less costly, and well worth the money - don't accept a westuit that does not fit you comfortably, just because it is $100 cheaper.
I bought a drysuit after a year of diving, so I could dive local quarries throughout the winter, and maintain and improve my skills. That was probably the most useful investment in scuba gear I have made. Now, I am used to cold, dark and low vis and enjoy it, or at least don't notice it. Hang in there! I bet you will find over time that quarries have their place in your diving adventures.