I think the name is pretty telling. If you need something to be GLOBALLY unique so all ambiguity is removed, use a Guid. If you need an item to be unique only among its peers, use something simple like a serial primary key.
The only major advantages of a serial primary key is (1) baked in support across nearly all existing storage medium, (2) simplicity in communicating verbally, and (3) storage size.
That being said, if the ID will never/rarely need to be communicated/keyed manually, and storage isn't of an upmost concern (such as in a document library where taxonomy is negligible compared to the primary object), there's not really a good reason to NOT use a Guid.