It would be cool, yes, should I now pour cold water on some of your dreams?
Successful terraforming would take generations before any sense of 'completion' had been achieved, perhaps on the order of a few hundred years. Of course, the ideas of how to go about doing it have been around for long enough, and as more and more is learned from what we are capable of sending to Mars (rovers and the like), more and more can be learned about how best to go about terraforming.
Seeing as we haven't started the process, and don't look like starting any time soon, it's a really rather distant pipe dream - we might want to scale it back a bit, if you want things to happen faster. Bases and extended stays would be nice to see, but again on Mars, within our lifetime, doesn't seem too hopeful there. The Moon perhaps, if anyone can be bothered to have a look. Even an asteroid might serve some interest (there's some fascinating ideas about mining asteroids for resources, so that might be one to look out for).
But enough cold water, because maybe, juuuuust maybe there'll be a push for a manned Mars landing. Obama's said he want's to see it by around 2030, Congress approved the idea I think, but then you still need to develop eeeeeverything that goes along with it, and you still need to learn an awful lot, especially about long distance and time spent in space - can humans get there in one piece, in a fit enough state to actually do something useful?
Let's not forget that human space exploration is only 50 years old, we're still learning how to crawl, let alone walk. But, set your mind to it, set yourself a goal, and the Moon landings have shown what we can do - just need to put in the time, effort, and the cost to do more.
