The comparison page link is comprehensive, nice!
To summarize the main point of roll-your-own vs. a pay-per-request api the main point seems to be updating with updated/new OSM data.
In terms of comparing Google Maps vs. Open Cage vs. roll your own OSM / Nominatim what would you say are the main features that are different? (not dev time or infra stuff- just what's different about the request/result)
There is a list here (vs. Google) https://opencagedata.com/guides/how-to-switch-from-google-ma...
though really the key difference is the fact that we use open data. Googles data is not open, this significatly restricts what you can do with the data.
And here is a similar comparison versus running your own Nominatim https://opencagedata.com/guides/how-to-switch-from-nominatim
Please let us know if anything is out of date or can be made more clear. Thanks.