Short version: what are some interesting hyperdoctrines for classical (not intuitionistic) first-order logic, that are not models in the traditional sense? (Where the terminal and initial hyperdoctrines are "uninteresting".)
Long version:
The categorical semantics of first-order logic are given by hyperdoctrines. This is in contrast with the traditional semantics in terms of model theory.
In brief, in the traditional picture, we think of the semantics of a first-order theory as being some set $U$ ("the universe") plus an interpretation of every constant symbol / function symbol / predicate symbol in that universe (so, eg, for the unary function symbol $f$, the model provides $[\![f]\!] : U \to U$, and so on and so forth.) We can then interpret every proposition in the theory, interpreting (for example) $f x = x$ as the subset of $U$ where $[\![f]\!]$ is fixed.
By contrast, in the categorical style, we think of the semantics of a first-order theory T as being a hyperdoctrine plus some interpretations for the symbols and etc, which I'll call a "hyperdoctrine for T". This is more-or-less a stream of lattices, equipped with some strucures relating the lattices to one another, plus interpretations for the various symbols in terms of the lattices. Roughly speaking, the nth lattice is thought of as the possible interpretations of a proposition with n variables free, and the structures relating the lattices are about substitution and quantification.
The latter framework is more general. For instance, we can turn a traditional model for a theory T into a hyperdoctrine for T by letting the nth lattice be the lattice of all subsets of $U^n$. But we also have new hyperdoctrines: most notably a terminal one, corresponding to the choice where every lattice in the stream is the trivial (one-object) lattice; and the initial one, corresponding to the syntax.
And presumably, the categorical semantics also add a whole host of more interesting "new models". Like, presumably there are hyperdoctrines (for, say, 1st order arithmetic) that assert some combination of sentences, that no traditional model asserts. (Such combinations must necessarily be infinite, on account of the traditional completeness theorem, but still. (ETA: Not quite; see the comments below.)) And, like, yes, the terminal and initial hyperdoctrines show us some boring ways that this is true, but surely this newfound generality does more than just bolt a new "initial" and "terminal" model onto the traditional models. So, what are some of these new models?
(Ideally in the classical setting; I know we can get topological models and stuff if we consider intuitionistic logic, but it still seems to me that even classically we must have additional interesting hyperdoctrines, and I'd like to know what they are.)
(Ideally I'm looking for hyperdoctrines that feel motivated in their own right, more like "the lattices contain only the propositions that satisfy the following natural property" than "well given any hyperdoctrine we can generate a new one by bolting on a spandrel; just do that to the initial model". My apologies for the vagueness of this constraint. What I'm really after here are intuitions about how hyperdoctrines expand the space of models.)
(If I'm wrong in my assumption that there are interesting hyperdoctrines aside from the initial and terminal one, I'd also be happy to hear about that.)