Andy,
Depends what you use your computer for and how much you use it.
If you are doing something that is constantly creating and deleting files then yes, it's a good idea for perforance. This would include things like lots of downloads or heavy web surfing (to many constantly different sites), video recording and especially editing, graphics manipulation, audio editing, etc.
Anything that involves a lot of temp files or keeping multiple copies of a file around is going to be affected by this. The larger the file (in other words, how many blocks it takes up, the bigger the file, the more blocks) the worse it will be.
The most extreme example is video editing, because the file sizes are huge and when you have a single multi-gigabyte sized file that is scattered allover the disk and then you want to edit it (say remove the commericals before you burn to dvd) then you are creating a multi-gigabyte sized temp file that could also be scattered allover the disk, will just absolutely murder your render and transcode process times - depending on the MPEG format, you could end up taking longer than the show actually is to write out the new file.
For video editing, graphics manipulaiton and audio editing systems it's a total waste of time to run the built in software, it just can't handle what it will be faced with. Spend the $29 to $59 for Raxco or Diskeeper.
Light use systems, yeah, whatever. Once every year or ever few years with the mickeysoft installed version ought to hold them.