Newport News is a small station, no Aisle service, but they do have a booth in the parking garage next to the cars (booth closed on Saturdays, you have to go to the terminal counter then). I've rented frequently there for local rentals. As Emerald Exec, I've always been upgraded to full or premium or minivan if I wanted. Pretty much they give me a list of 4-5 cars to pick from, I take whatever has working satellite! No special cars there, just regular ones- impala, camry, 300, town&country, etc. Though I did get a camaro convertible the other day!
They interchange freely between National and Enterprise fleets. So basically your average small station selection, with friendly staff.