Geometric analysis of the pseudo-projective curvature tensor in doubly and twisted warped product manifolds