I don't know if you know this but there's a solar eclipse happening this April and people from all over the world will be traveling to the tri-state as we are in the path of totality. If you were hoping to book a camping spot for the eclipse, you are probably out of luck...
If you really want to see the night sky at its finest, you need to get far away from city lights. I found a Missouri cabin that is kind of hidden away from civilization where this is possible and yes, the star views here are epic.