...the remoteness isn't going to be for every camper out there.
Don't get me wrong, I still give this place the highest review possible! A friendly and knowledgeable 1-man staff, a general store with the essentials, and unparalleled views of the park. But there are a few things I could have known that would have better prepared my car-camping trip.
This might be common knowledge to the avid national park geek, but I didn't know this until I spoke with the CLNP rangers at the station 1.5 miles away. The three districts of the park (Island in the Sky, Needles, and Maze) are each developed for tourism in three different ways. Each is more remote than the last, thus the Needles falls into the middle of the three.
That being said, Needles Outpost isn't going to be for every camper. It was quite hot in the peak of summer, too hot for my dog (high of 100+ F). This was exacerbated by the very fine red stand that was too hot to the bare-skin touch.
But the roads in are all paved and fine (save the last half mile, which is gravel). Our hatchback with 5.5 in of ground clearance made it just fine.
TL;DR. Just go, but be prepared for exactly what the desert has to offer. This is, as far as I've been able to tell, a unique opportunity with wondrous beauty that will foster lifelong memories. I can't wait to be back! (though with slightly cooler weather next time).