Talking about the fairground ride here? Think you're right, you would only feel the force of the thing you were sitting on, although that would be angled in towards the centre of the roundabout.
If it's like that enclosed rotating room I was in once, it's when you actually move yourself instead of sitting or standing still that the rotational reference frame weirdness starts... that particular ride doesn't have much opportunity for that, but if you tried walking on a big rotating roundabout, you would feel it. Although unless the roundabout was enclosed, it wouldn't feel so weird because your cerebellum would "know" you were on a rotating platform. If it was enclosed, it would start looking at the walls stationary to yourself and start getting the wrong idea. don't know what your inner ears would be doing, but it probably wouldn't feel pleasant!
Think you're right about the space-station as well. I haven't worked out the magnitiude of the artificial gravity, although I'm sure someone has. It would be weak in towards the centre where the walls of the docking bay are, anyway. I read a long time ago the size of carousel they thought you would need before it was tolerable and didn't make you sick. Expect it's pretty large! Sometimes you see stations with those huge rings around them, or pods out to the side... maybe these are built out to be luxury living areas, as the further out they were, the more gravity they would have? Think Coriolis effect would be the same, as the formula depends on the angular velocity, which wouldnt have changed.
Raises a lot of questions about people living in space for long periods. The game gives me the impression that lots of people live in stations rather than on planets, and most of those outpost stations wouldn't have gravity worth speaking of. Im sure humans can adapt to a lot mentally, especially if they're born to it, but they must have solved the problems that some with extended low gravity. Genetic engineering or medicines, I wonder?
That's an idea. Maybe people who aren't used to space stations, even ones that can approximate proper gravity, get something like sea-sickness on them...
I must have a shot at writing an action scene set in a space station's docking bay!