I am aware that compactness fails on finite models, but the common counter-example uses models of arbitrary big finite size. So if we bound the size what results can we get?
Assume we have an infinite set of sentences $\Sigma$, of a language of first order logic $\mathcal{L}$. If there is a natural number $n$ such that every finite $S\subset\Sigma$ has a model of size $\leq n$, then does $\Sigma$ have a finite model? How about a model of size $\leq n$?
If the language is finite or there is a $k$ such that every function has at most $k$ arguments and every relation is at most $k$-place, we have finite many structures of size $\leq n$ of $\mathcal{L}$, let's call them $N_1,\ldots,N_m$. If for every $i\leq m$ there exists a finite $S_i\subset\Sigma$ such that $N_i$ doesn't satisfy $S_i$, then $\bigcup_{i\leq m}S_i$ wouldn't have a model of size $\leq n$, and thus we get that one of the models satisfy every sentence of $\Sigma$. Is this argument correct? And what about the general case, where we don't restrict the language whatsoever and the structures are infinite many?
For the general case, without any restriction on the language, the Compactness theorem does hold for models having a specified finite size. To see this, argue as follows: suppose that every finite subtheory of $\Sigma$ has a model of finite size at most $n$. Let $\Sigma^+$ be the theory obtained by adding the axiom "there are at most $n$ elements." Notice that every finite subtheory of $\Sigma^+$ is satisfiable. Thus, by the ordinary Compactness theorem, $\Sigma^+$ is satisfiable. Hence, $\Sigma$ has a model of size at most $n$, as desired.