Bounded and unbounded behavior for area-preserving rational pseudo-rotations