I have to agree- I live 2 hours away from Launch Pads 39 A/B and have never gotten over the awe and inspiration of manned spaceflight- shuttle or satellite heavy lift rocket...
Gene Cernan was asked at a Special Breakfast out at The Cape around this time last year how he felt about manned exploration of the moon and he said something interesting... Understanding that it was only how he felt and what his expectations of the space program at its time:
He mentioned that "The Gen Xers" [those of us in our 35 to 45 range] were shown a peach and sold a prune. We languish in Low Earth Orbit when we should already be sending people to a Lunar Disney or such...
I tend to agree with him on that notion- the privatization of space may help some of that, but to what degree [if at all] worries me.
As to what the equipment and tools will look like, my guess is that we'll see a more refined Apollo-esque lunar/launch vehicle with the possibility of heavier lift capabilities depending on whether we actually use the ISS as a platform or not...
I for one am very excited about the possibilities- but it's some-what want with dread at how it could get loused up...