We’ve been playing around in Ninox for Mac and iOS, and exploring both the iCloud and Ninox Cloud options. Ninox allows for the local and privately-shared databases you’re after.
The interface isn’t what I’d call phenomenal, but it is much more “Mac-like” than not (especially with what passes for a Mac app these days); it takes some getting used to if you’re coming from a wealth of experience elsewhere, and currently lacks a fair amount of accessibility functions (too much mousing, not enough keyboard), but it appears reasonably powerful, even if it currently lacks the more powerful integration and maturity of FMP.
But, you can trial the Ninox Cloud for free, and the Mac version for local/private/secure development is only $35 with a free iPhone app; the iPad app is (I think) ~$15. You can place your db in your personal iCloud (or Dropbox, etc.) and use across devices, which is nice if you don’t have to meet federal requirements.
We bought several Mac copies to show our support and with hopes that the developers will continue to invest in this relatively young native Mac app.
Templates are what you’d expect; tutorials are messy and already out of date as far as images matching current product, but I often take that as a good sign that necessary development is outpacing documentation.
Oh, and support is excellent; they will schedule one on one online support via telephone or screen sharing.
EDIT: Forgot to say the reason we looked to adopt it is that it can directly import Bento databases, which our people were looking for when Bento got the knife.