Hi aiop. Sorry that phinds has been a bit short with you; I understood immediately what you were getting at. You simply were calling centripetal force "gravity" - simple mistake.
Earth's net "tug" at the equator is indeed lower than at the poles for two reasons. One is exactly, as you noted, centripetal force. But the other less obvious one is that things at the equator are further from the Earth's center of mass, as Earth is oblate (fattened) there due to its spin. It turns out that this latter factor has even more of an effect than the former.
If the Earth suddenly stopped spinning, well, obviously the surface would be in complete chaos due to the rapid deceleration ;) But even if you were to "damp" that slowdown so that every object (not to mention the oceans) didn't keep flying in the direction that they had been moving, you've still got a big problem: now there's no force propping up Earth's equatorial bulge. So the Earth will collapse into a new equilibrium stage, with mass steadily shifting from the mantle at the equator toward the poles. This process will involve a tremendous release of energy, and probably resurface the entire crust (aka, the worst series of volcanic events in Earth's history since the collision with the moon's progenitor!)
As for the other issue - "artificial gravity on space stations" - as was mentioned, that's not gravity either, that's just centripetal force. There's a really obvious difference with it, too - tidal forces. Imagine you're rotating in a circle twice your height. Your feet will be moving twice as fast as your head. Which means that they experience twice as much force, which means that tidal forces - that is, a difference in accelerations between different locations - will tend to pull the blood away from your head to your feet! Hence if you're using such an "artificial gravity" - again, stressing that it's not actually gravity - you need to have as wide of a radius as possible for crew comfort!