Pigeon Forge is a pretty cheesy tourist trap area. Are you specifically wanting to stay there, or just that general area?
We've stayed at Anchor Down in Dandridge, about 20 minutes up the road. It was a gorgeous RV Resort. There are a couple campgrounds near there that looked nice, specifically the Tailwaters Campground just below the dam on Douglas Lake.
If you want to be closer to Gatlinburg, which is much more beautiful an area (but still a fun tourist trap), there are plenty of campgrounds that way as well.