All porn comments aside. It would be pretty amazing, but its not going to happen for a long time, and if it does happen within "Our" lifetime, it will probably be near the end.
But really, If everything you ever wanted to experience was right infront of you, what reason would you have to ever leave your computer, or you home. (Aside from eating, and going to the bathroom. lol)
You wouldn't need any kind of human interaction at all.
We all know how many people sit in their basement 24/7 doing nothing but surfing the internet and playing online games. But thats just scary.
That would probably screw up the balance of everything.