What water does in zero-G:
Artificial gravity is found only on Zuxian ships (like the Kalvania and Extravia), using, by best guess, electromagnetic effects to simulate the pull of gravity in a direction relative to the vehicle and its current orientation. For all intents and purposes, the feeling and function of this gravity-like effect is identical aboard the ships as on Sirian Planet making transitions between the ships and the station slow to allow time for the transitioning members or objects to adjust to the new local gravity mechanics.
The 'gravity' of some parts of Station Prime isn't real gravity, either - it doesn't act on you constantly, it only acts on you when you are in contact with and moving with the spinning surface so that the centripetal forces can press you against the 'floor'. Basically, inertia says you should go 'straight' but the turning curved floor underfoot says you should go up. It uses friction to put pressure under your feet... and you end up feeling the pressure as if it was gravity. This is why objects sitting on the floor will also stay put - friction acts on objects too.
This is similar to the acceleration you feel when you start a car - pressing you back into the seat. It's not that gravity changed directions - but the movement of the car acts on your body and your body doesn't want to move - so you feel pressure. The same forces push you to the 'floor' on a roller-coaster ride or against the side of a car on a sharp turn.
So how does all the spinning look when you're standing in the middle of the Station? If you were spinning at the same rate as the Station? Everything would look still but won't feel any pressure to go towards the wall. If you've ever ridden the Gravitron carnival ride - the operator in the center of the ride doesn't feel the same forces as the riders. That's how he can keep his footing while you're pressed against the wall.
But what if you were floating free like a balloon and NOT spinning with the station? It would look like the Station was spinning all around you. At really high speed. If you started towards the station wall - and didn't make any effort to sync your forward movement with the Station spin... well - landing is gonna hurt a lot. And by a lot - like an extreme version of road rash as you bounce along the hull until you hit something and go splat like a bug on a windshield. It's that or when you hit the surface, the friction starts trying to accelerate you. Since your current momentum is NOT to move with the Station... you'll experience extreme forces - like road-rash at high speed. Not much better than the windshield effect really. Just more rolling and tumbling.
What would that look like to a guy standing on the inner surface of the Station looking towards the center? Like in the Park? Well, from their point of view, you're flying around and around the center of the station in the opposite direction of the Station's own spin - spiraling outwards... until you hit the ground at unpleasantly high speeds.
Point is - these sort of details for most RP are not hugely relevant. The Station is built to conserve space - so most areas of the Station are in Microgravity conditions and are small hallways and the like - places where you're not likely to go flying off. Section B does have more open space to accommodate the Park, but again, a large chunk of B-Sec's center is taken up by fish (spinning fish!), the reservoir, and various labs. Open 'vertical' space isn't commonly available on the Station - space is just too damn valuable.
Centripetal force: http://en.wikipedia.org/wiki/Centripetal_force
The "Wall of Death" motorcycle trick uses the same principles: http://en.wikipedia.org/wiki/Wall_of_death
The "Gravitron" carnival ride: http://en.wikipedia.org/wiki/Gravitron