I usually end up installing service packs but not for at least the first few weeks after they are released.
Right now, Service Pack 1 for Vista is in Beta mode. Unless you are just too eager to wait, wait for at least 2 weeks after it is released before installing it.
For Office 2007, service pack 1 has been released. For the pro version, depending on what features you have installed, you may need separate service pack downloads for some of the associated programs.
You should however, install all security and critical updates as soon as you can. Security updates protect against known and published security holes. Critical updates clean up problems related to software or hardware issues.
Service Packs from Microsoft usually are more than just a collection of critical fixes. They usually include updates or new features that are not available as individual downloads.
Here is a link to the Microsoft Knowledge Base Article on Office 2007 SP1.
http://support.microsoft.com/kb/936982
After reading the article and list of fixes you can decide if the service pack is worth installing.
Chas