Is it worth upgrading to a 1000Mbit network for between my home computers?
Depends if you're doing a lot of file sharing between your computers! If not, then no.
I'm playing a lot of games with my flatmates - is 100mb still enough to not give any lag?
More than enough unless you have several people also streaming videos from each other at the same time!