When someone leaves me a message, I get an SMS with the message and caller details. I've been using OpenCNAM (https://www.opencnam.com) for the caller ID look-up.
I implemented something similar for our office so that each person has a proxy number that can be given out to clients. Voicemail is handled by a similar app, and each person also receives a Slack notification for an incoming call or voice message.
Lookup by Twilio is a bit different than OpenCNAM, but also pretty similar. They're both pretty affordable, though in the end, I'll likely create our own lookup database that we can customize.
For me, the most immediately useful info is the state/province as well as country of the incoming call. It appears that with Twilio Local, on the latter comes through. I did some tests of Lookup with a bunch of numbers, and the additional info that comes through for the paid portion of things doesn't seem that particularly useful. The (free) "national_format" is nice, but I'd say the most valuable part of the service is quickly identifying invalid and VoIP-based numbers.