It does seem to vary with model and year. I do know that the 2004 Z4 sport button did the more sensitive throttle, cut the steering boost a bit, and on auto versions put the transmission into sport mode shifting.

The X5 owner's manual reads like the button only affects the suspension, FWIW.