Thanks for checking. I am getting the leaning effect because I had set up the controls to emulate the pedals. Check what controls have been set up in F-Zero by going to:
Options -> Controller -> Customize and press the A button again when it asks for the controller
If, in the background, you see a picture of the steering wheel by itself that means the pedals are not being emulated/detected by the game. If you see both the steering wheel and the pedals beside them, then the pedals are being detected.
This is what it looks like with just the steering wheel:
This is what it looks like with pedals detected:
Constant force is the correct type of effect. It controls a magnitude (strength) as well as polarity (left or right force). For example, hitting a wall on your right will jerk the wheel to the left. Also, the spring force (the centering of the wheel) is totally controlled using force feedback sent by the game. If the effect were to change to a sine effect, you'd get a pulsing feedback which is not what we are after. And yes, F-Zero GX uses the term Rumble to mean Force Feedback too.
On my Logitech Driving Force Pro PC steering wheel using the Constant force effect, a positive magnitude from 0 to 10000 jerks the wheel to the right, where 0 is a weak movement, and 10000 is a strong large movement. A negative magnitude 0 to -10000 jerks the wheel left, where -10000 is a strong movement to the left.
I'll keep experimenting with the controls. Shame you don't have the pedals. They are not vital, I can probably work it out after using a bit of trial and error.
Here's a list of GameCube games that use the steering wheel:
4x4 Evolution 2
Burnout 2: Point of Impact
Dakar 2: The World's Ultimate Rally
F-Zero GX
Hot Wheels: Velocity X
Mario Kart Double Dash
NASCAR HEAT 2: Dirt to Daytona
NASCAR Thunder
NASCAR Thunder 2003
Need For Speed Underground
Need For Speed Underground 2
Need For Speed:Hot Pursuit 2
PRO RALLY 2002
R: Racing Evolution
Rally Championship
Street Racing Syndicate
The Simpsons Hit & Run
V-Rally 3