Almost all states allow you to transit - you can land there and leave from there. In Mass. when we went through you could come and go onward in your trip as long as you were not staying overnight (24 hours). I'm thinking NY and NJ were the same at that time (late Aug, early Sept.) Air/train/rental car, etc., connections were all allowed. NY/NJ/CT regs have morphed somewhat for in-country travelers. Quarantine can be circumvented by testing instead. Not sure if that applies to people coming in from red zones overseas (and the UK is a red zone), as I haven't needed to check. The last I did see, none of the quarantining requirements were impacting anyone who was just transiting through.
Essential travel in the UK's definition tends to mean bona fide business purposes (business that had to happen and could not happen via remote communications), for medical care, for shopping for food. It's not that different here, from what I can see. It's not for going to visit relatives you haven't seen in ages because you miss them, unless one of them is on their death-bed.
I suggest you start at your destination state and work backwards. Find out what that state requires. NC doesn't seem to REQUIRE a lot. But they do recommend best practices.
https://www.nc.gov/covid-19/covid-19-travel-resources You state you don't want to get stuck in a hotel room. If you are quarantining (best practice) at a private home, you'll need to be apart from everyone else anyway, so a hotel room is actually probably safer for anyone you could potentially infect by being in a private home. Remember that this disease is airborne and you can pick it up at home, on the way to the airport, at the airport, on the airplane, and the reverse and potentially never know you have it.
I believe you will be quarantining when you return, assuming the UK lets you leave in the first place. The rules can change in any of the locations at any time, depending on the need.
Now is not a good time for non-essential travel.