Keep at it, once you're over the initial shock it'll be worth it.
Certainly give it more than 1 or 2 dives.
I can remember clearly my first OW dive. It was off a large RIB with the air temperature about 10c and water temperature 6c.
I rolled off the boat into 17m of water, did the surface check,signals and descended. As soon as my head went under the water i very nearly paniced and bolted.
I wasnt ready for the cold that made my face sting, it was like descending through milk in approx 1-2m visibility and we hit kelp at 6m which we had to batter through. That descent was the longest 1 minute of my life and i considered giving it up there and then. I was later told i was wide eyed and the instructor debated several times whether to abort but didnt.
However, we got to the bottom, i collected myself and had a very enjoyable 40 minute dive through rocky gullies and outcrops of kelp.
The second dive of the day was onto a wreck. As we descended down the shot line which was at 45 degrees the current was strong and my brief was "Roll off, get to the shot, get down it and meet on the bottom". I did, once again what i thought was extreme cold, poor vis and current got to me but once again once i got to the bottom i was fine.
The point im making is i COULD have given up diving there and then on that first descent but went through it and am now VERY VERY glad i didnt quit.
The 6 months of weekly pool training and drills is all very well but open water with poor vis, the cold, the bulky kit and currents is totally different and id venture no amount of pool preparation will get you ready for it - its something you just have to do and get through.
Underwater is an alien world and it does take getting used to. Even now before i dive i get a little bit jumpy and run scenarios through my mind and i think thats good - respect the sea, realise it CAN hurt you if you are complacent but other than that realise if you stick to training and plans along with practice it'll tolerate you.
As for other scarey experiences, mercifully those have been very few and the only real incidents ive ranked as annoying as opposed to scarey. Things like buddy separation aborting a dive after only 3-4 minutes, minor entanglement and so on.
The only one i can think of this year that id class as dicey is we were dropped onto what should have been a wreck but wasnt. We drifted around the lee of the islands and got caught in a VERY strong and infamous current. We put the DSMB up as pre-briefed so surface cover could follow us but as we were drifting so fast rocks were coming up off the bottom and we were being pulled into them as we couldnt see them coming. We attempted to rise above them and reel in some line but even with 2 of us pulling the current was too strong to reel in. At 2 points we got "trapped" pulled tight against rocks and twice considered the pros and cons of realeasing the reel (major con - surface cover wouldnt find us). Eventually we got separated, i surfaced and my buddy hadnt. After 5 minutes he still hadnt surfaced and we all got worried in the boat - he wasnt carrying his own DSMB. Eventually though he appeared some 200m off the boat and we got him on board.
I checked my contents gauge and id really sucked through the air on that dive with the exertion, my SAC was nearly twice normal and id given myself a headache im guessing from CO2 retention as well.
All in all though not a good dive and its not a good feeling surfacing and several minutes later your buddy who you saw only a few minutes ago is nowhere to be seen.
---
Id just say, give your local diving a few more goes - give it a chance. Once you get used to dark, murky waters you may well be surprised as to how good dives can be. If you dont like it then fair enough, stick to warm, clear waters but you could be missing out if you stick to that straight away.