LOL, "endless sprawl in every direction" translation the residents of Raleigh enjoy nice big yards and are not in a crowded city with endless noise and pollution but by all means stay away e-coli.Raleigh is terrible. Don't move here. Tell your friends. -Saw that on a bumper sticker.
There is a transit system (bus). If you meant to say there isn't a train system, then yes, you'd be correct. There's also a significant network of Greenway trails that stretch all across the region. It's actually quite walk/bikeable.