My friend and I recently stayed at the north ridge campsite, which is the tents only site at Tar Hollow State Park. I had both positive and negative experiences. Let's start with the positives. It's a very secluded campsite so it really feels like you're one with nature. The pit latrines are convenient for those emergency situations but they're not the cleanest but it is not a far drive to the flush toilets at the RV campsite area near the camp store. Site 106 is a great site if you choose to stay here. It is very flat, one of the most flat sites (I think 105 is more flat) and so my night's sleep was great.
Now for the negatives, which sadly outweigh the positives for my stay.
You are right next to your camping neighbors. I have terrible luck and ended up staying next to a very inconsiderate and loud group that included their many dogs. Normally this wouldn't bother me but I could hear all of their conversations because we were so close to them. You can hear snoring and other "nighttime" noises so just be aware others can and will hear you. I wasn't able to find the water spigot right away because someone set up their tent right next to it but then was able to find it once they moved their tent. This is more of a negative of the State Park but the hiking paths are not clearly marked and I am embarrassed to admit I did get lost in the woods. The map they have is in black in white but the park uses a color system. This could be solved by taking a picture of the colorful map right by the fire tower.
Overall, I don't think I would choose to return to this site for camping because you're just way to close to others around you.