cache size ont he HDD won't make a difference when gaming since none of the files will already be in the cache.
But normally, more is better and is not noticeable on a user level as long as you have enough; but too little is much worse and is something you will notice.
I doubt there are any drives with "too little" these days.