Yes! I avoided Napoli for many years after several bad experiences just transiting at the station or between the station and the airport. And the trains between Napoli and Sorrento are enough to turn anyone off for life!

But just before covid I stayed there for a few days and loved the old parts of Napoli - totally different to the area around the station. So I would recommend spending your time in Centro Storico - just pick some small authentic restaurants for some amazing meals, walk the old streets and soak up the atmosphere.

I know that didn't answer your question but it might open some options.