I am genuinely curious just what 'horror stories' are being passed along though.
I never really heard any horror stories about being an NFO at OCS, there were a lot of people there who wanted to be NFOs. I heard more stories about the attrition rate that goes along with being designated at a pilot.
One thing I will say, OCS will test how committed you are to the Navy. If you went in only wanting to a be a pilot, and not an officer, then it'd be a horror story to be designated NFO. Don't get me wrong, as an NFO you get to do some awesome stuff, you're an officer, and you get to serve your country, but it's obviously not for everyone.
This is probably one of the best times to be a pilot in recent history. The Navy didn't work out for OP, but he still has some amazing opportunities ahead of him. He can continue in his civilian aviation career and live the good life at an airline, reapply for the Navy, apply for the Air Force Guard or Reserve and still fly for an airline, fly C-130s aerial firefighting etc. Keep your head up, it's a great time to be a pilot!