I work in RTP and have spent the past couple of weeks tracking down various ramps at Jordan.
If you are near 55 or Fayetteville Road, probably the closest ramp to you on Jordan would be the Boating Access Area at Farrington Point (6 free ramps). Take Fayetteville Road to a left on 751. Take 751 to a big white church (I forget the road name, something church or chapel). Take that to where it dead ends at Farrington Point road, take a right across the bridge and your first left to the ramps. If you go to the two ramps on the left, there is a beach and it looks like people shore fish there, otherwise go straight to the four ramps at the end, since there is now a pier there to tie your boat up at while you are parking. It is 15.2 miles from the intersection of 40 and 55, where I work, so if you are closer to Southpoint, you will be even closer.
If you are shore fishing and took a left on Farrington instead of a right, you would pass a Fishing Access Area on your left with a fishing pier before you get to 64.
You are also probably within 20 miles of Falls Lake, can get there to a big pay ramp by taking 50 north off 540 across the lake, or take 98 east a couple more miles to Six Forks Road to 4 free ramps at the Boating Access Area at Upper Bartons Creek. If you were to keep going east on 98, you would cross Falls Lake and there is a Fishing Access Area with parking lot just over the first bridge to the right. Comes up fast though, so be alert for the sign.
I really haven't tried Jordan at all, and have not had a lot of success at Falls (mainly crappie). Since I live all the way over past Wake Forest to the east, I just run up to Kerr lake, bigger lake, less people, and I have caught more fish there. For your area, Jordan is the big lake, known for crappie and striper.
I don't know if a guide that goes by "hotspot" posts here or not, but if not, look on thehulltruth website under the Carolinas section, lots of info on Jordan there.
I have not tried any of the ponds/small lakes over there, but the previous suggestions were good ones to check on.
Good luck, lots of places to explore out there with fishing.