I have a 1 gbit connection at home and there is little difference to the 100 mbit connection I have at my parents. The gains are pretty much the same as the difference having wifi and gigabit LAN. Transferring large files etc. are in the minute range rather than tens of minutes or even hours.

But 10mbit is definitely not enough to use the internet effectively, hell, my HDTV soaks up that much just watching any a generic HD channel, if you had 2 TVs running it would slow to a crawl.