It’s the Spruce Creek trailhead to the left of that first main parking lot. It’s a pretty section of trail along the creek in the woods with emerging views as you get further along.
So...if you can’t drive in or don’t want to, that’s the way to do it.
I am 98% sure we are talking past each other. I think you're describing a trail at the first Mohawk Lakes parking area.
You can see the 2WD parking lot on Spruce Creek Road pretty close to its intersection with 9 :
https://www.hikingproject.com/trail/7006806/mohawk-lakes
After that, Spruce Creek Road is considered 4WD, and it's a fair distance (over a mile) to the labelled Mohawk Lakes trailhead.
There is a trailhead at the first Mohawk Lakes that leads almost all the way to the end of the road - but the road to that first trailhead is 4WD, and (to my inexperienced eye) not appreciably less technical than the remaining short bit of road. Unless I completely misunderstood the situation, that trail goes from the first Mohawk Lakes TH to the end of the road (literally) - I don't think it starts all the way back at the 2WD trailhead.
Am I mistaken?
The last little bit of road from the first Mohawk Lakes trailhead to the absolute stopping point (metal barrier) is negligible - 1/4-1/3 mile. But it's boring, just like the road before it, so I suspect it would be worth it to take the trail for even that short segment.
Thanks to people parking on both sides of the road, even if you managed to park at some point along the 4WD road after the Spruce Creek (2WD) trailhead, there's a lot less room to maneuver on the way out. I swear that many people drove until they realized the next obstacle would be too much, then just stopped.