Does Spatial Cognition Emerge in Frontier Models?