In logic, the completeness theorem in propositional logic consists in showing that a formula is provable if and only if it is a sentential tautology.
Suppose now that I have a set of non-logical axioms on top of tautologies. Does it make sense to look for a weakest form of the completeness theorem in that case?
If I understand the question correctly, your statement of the completness theorem is: If $\models \varphi$, then $\vdash \varphi$.
This is often called weak completeness. In many logical systems, such as the standard systems for propositional logic and first-order logic, we actually have strong completeness: If $T\models \varphi$, then $T\vdash \varphi$.
Here $T$ is a theory, or a set of non-logical axioms. This is usually what people mean when they talk about the completeness theorem.
If $T$ is a finite set, say $T = \{\psi_1,\dots,\psi_n\}$, then strong completeness follows from weak completeness in most logics (as suggested by HallaSurvivor in the comments). The argument goes like this: If $T\models \varphi$, then $\models \left(\bigwedge_{i=1}^n \psi_i\right) \rightarrow \varphi$. By weak completeness, $\vdash \left(\bigwedge_{i=1}^n \psi_i\right) \rightarrow \varphi$. Then $T\vdash \varphi$.
To carry out this proof, all you need is (a) to have the appropriate syntax to form the sentence $\left(\bigwedge_{i=1}^n \psi_i\right) \rightarrow \varphi$, (b) for this syntax to have the appropriate semantics so that the first step of the argument works, and (c) for the proof system to be sufficient for the last step to go through, i.e., to convert a proof showing $\vdash \left(\bigwedge_{i=1}^n \psi_i\right) \rightarrow \varphi$ into a proof showing $T\vdash \varphi$. Again, almost all standard logical systems have these features.
On the other hand, when $T$ is an infinite set of axioms, it's not so clear that weak completeness entails strong completeness. For propositional logic and first-order logic, this is essentially the content of the compactness theorem, which says that if $T\models \varphi$, then there is a finite subset $T'\subseteq T$ such that $T'\models \varphi$. We can then apply the argument above to $T'$.