I agree you can't put all diveshops into that same category, I know you said local but the diveshop you may be happy with is local to someone. The thing I hated was a couple of my local diveshops advertise $99 certification and when they get you in thier shop they try to get you signed up before you ask too many questions about what the price actually covers... The one shop I went to had me up to $450 by the time I walked out and that was solely pool dives. They told me that I couldn't use the equipment I bought second hand unless they overhauled it @ $125 an item, a visual and/or pressure check wouldn't be good enough... But they had gear I could rent @ $100+. I hope that shop doesn't last long...
Then as I was driving back from the beach I noticed a shop having a sidewalk clearance sale and stopped in to see a lot of really great prices, asked them about certification and they were having a sale that day for that too, $235 books and all, out the door... They did a free visual and pressure check of my equipment which they had said all looked new before hand and only even checked it because I asked. They had gear that you could borrow, no charge and they told me to hang on to it until I finished the courses and dives. They are a bunch of quality guys, great shop. Since I got certified through them I also get a 10% discount... Normal price would have been $285...
We trained in a nice rec pool the first dive, second dive was a bigger nice olympic pool. Third dive was in weeki wachee at the spring, fourth dive was out of venice off of one of their dive boats @ 40'. One tank at a culvert site and the second tank at a barge where I got to see the biggest barracuda I have ever seen anywhere, the thing had to be close to five feet... Great shop, great people, great prices...
I also found a great local dive shop, so they are out there. Sorry to hear you have had such bad experience, keep looking and I would bet you can find one out there you will like...