As Mad Scientist said in the comments, measurement of the transverse signal in NMR occurs in both the $x$- and $y$-directions. This is known as quadrature detection. In practice this is not achieved with two detector coils, but rather with a "trick" which is described more fully in Keeler's Understanding NMR Spectroscopy, 1st ed., section 5.6. For a more mathematical description, see also Appendix A.5 of Levitt's Spin Dynamics, 2nd ed.
However, a rf pulse centred at $400.002~\mathrm{MHz}$ would be less effective at exciting the spins (as it is further away from being on-resonance), and essentially you are throwing away half of the rf pulse (any components of the rf pulse with frequency greater than $400.002~\mathrm{MHz}$ are wasted). So, it's preferable to put $\omega_\mathrm{rf}$ right in the middle of the spectrum; but as said before, that would necessitate quadrature detection so that you can obtain information about the sign of the offset.
As a final comment, the fact you note about how $\hat{I}_{\!x} + \mathrm{i}\hat{I}_{\!y}$ is the raising operator $\hat{I}_{\!+}$ is reflected in many books when they discuss coherence transfer pathways: often it is said that the detected signal has coherence order $-1$. This corresponds precisely to detecting the $\hat{I}_+$ operator, or specifically, one off-diagonal entry of the density matrix.