I’m a PADI dive instructor and have high regard for The Dive Shop in Fairfax VA. http://www.thediveshop-va.com/ Yes – a slog to get there – but they have 30+ years and a really professional staff. Definitely do your classroom & pool locally, then your 4 final open water “test” dives on vacation somewhere tropical. While some people do enjoy diving in the quarry on a regular basis – it is pretty misrable – cold & murky. Also, it is completely different from what you will experience in a tropical setting – full wetsuit in fresh water requires very different weight. But diving is about the coolest thing in the world – so definitely do it!