Singularities are defined properly by the following condition : For a spacetime $M$, such that every standard measurable quantity on it is defined (ie we won't allow the Riemann tensor to be divergent at a point and so forth), that spacetime is singular if there exists inextendible curves of bounded acceleration for which the curve's half-length (measured by some parallel transport of a tetrad) is finite.
These are a lot of specific conditions, but there are a lot of types of singularities, or non-singular spacetimes that may appear to be singular otherwise. Here's a few things :
If a spacetime is geodesically complete, it is still possible that it is singular. There are a few explicit examples of this [1][2]. They are fairly artificial examples, but they do exist, and although not explicitely said, the Riemann tensor, and therefore the Kretschmann scalar, diverges along non-geodesic curves (you can see it because part of the construction involves sections of spacetime conformally equivalent to AdS space, with factor $2^{-n}$, $n \to \infty$).
In the opposite direction, there are many examples where the spacetime has curvature scalars well-defined, but is singular. The big example are quasi-regular singularities, for instance. The example of a cone minus its apex is a standard example : it is locally flat, singular at the apex, but no extension of it is possible. As far as spacetimes go, there are many cases, such as the spacetimes for cosmic strings with angular deficits, or the Israel-Khan spacetime. Another case is when all curvature scalars are well-behaved, but the Riemann tensor evaluated with some local tetrad is divergent, such as the conformal Misner singularities, or tilted homogeneous cosmologies.
The singularities for which the Kretschmann scalar is divergent are a type of scalar singularities (singularities where polynomial scalar quantities built from the derivatives of the Riemann tensor diverge). I don't know if there is a specific test for metrics for this, outside of the obvious.