Conjure Spirit can be cast on almost any deceased person, although most generic characters will not provide any sort of useful information or interesting dialogue. However, there are a few characters who will provide the player with the information they seek, generally with regards to a quest. Some examples are:
Arcanum: Of Steamworks and Magick Obscura Wiki