What are the best jobs for a previous YN with a General under honorable conditions discharge?

I don't know your age or relative training and education levels, but the word "honorable" pretty much makes you free and clear to anyone evaluating you for employment who doesn't know the underlying situation of that discharge.

As I see it, things didn't work out, and the Navy didn't hold any ill will against you. You were both better off just going your separate ways.

That said............... If you are young, and you want to train and develop then there is nothing to stand in your way of becoming a brain surgeon or President of the USA.

If you want to leverage your military training in such a manner that you apply for positions were military service is evaluated and you provide documentation of a General Discharge, well, be prepared for explanations.

But, if you decide to go to business school for example, and want to go down a path of financial management your interviewer will probably say "thank you for your service".

HR, records management, payroll

That’s a clerk in the navy correct. I would say a medical clerk could be decent I guess