Here is a more algebraic perspective on your question. If $X=\text{Spec} (R)$ is affine and $R$ is a Cohen-Macaulay algebra over some field (this the following is true in more general setting), then $K_X$ is Cartier is equivalent to $R$ is GoresnteinGorenstein. On the other hand, $K_X$ is $\mathbb Q$-Cartier is the same as the class of $K_X$ is torsion in the divisor class group (assuming $R$ is normal).
So to find a class of examples, you need normal Cohen-Macaulay rings with torsion class group but not Gorenstein. If $R$ is a Veronese $S^{(d)}$ of $S=\mathbb C[x_1,\cdots, x_n]$ then $Cl(R)$ is always torsion, but $R$ is Gorenstein if and only if $d|n$ (Sandor's example is indeed the simplest one in this class, with $d=2, n=3$).

