Let's put it this way: If the Earth was spinning fast enough so that it attained orbital speed at the equator, then objects at the equator would be "weightless". However this still only results in the Earth making 1 rotation in roughly 90 min. Could you easily detect that you were rotating that slow?.
So while you could deduce the spin of the Earth by traveling North and South and noting the difference in gravity as you did so, and this difference would be easier to measure as the speed of rotation increased, you still wouldn't be able to "feel" it when standing in one spot.