I live in chapel hill and Burlington (KBUY) and RDU are exactly the same distance for me. Burlington is a great airport. Uncontrolled, but good Instrument approaches and a good rental "fleet" on the field. C172's with g1000, and some pipers too I think.
I keep my plane there...highly recommend it.
You likely already figured out that the field that's actually IN Chapel Hill doesn't have any rentals that I know of.