Smaller isn't necessarily better. Spindle speed (i.e. RPM) seek times and other factors play into the overall equation.
As far as how a faster drive will affect performance, I notice much faster windows load times, (9 seconds) faster program load times, and overall snappier system response times. Games will load quicker, but you won't see any noticeable difference once in-game.
I hope that helps.