Where should I be using it?

It makes sense to publish databases as Linked Data. Long-text documents can also be published as Linked Data but they are of limited benefit.