I am/was in a similar position as the OP, former sport bike rider, Boxster S owner, we also have a 335i (wife's car).

I didn't bother with Adaptive Drive. I traded in my much loved Cayenne S on the X5d, with or without Adaptive Drive these big suvs are not going to be sporty enough to scratch the itch (the Cayenne is more fun to chuck around). When I got the Cayenne it was supposed to be my only vehicle, and as good as it was it wasn't good enough to keep me from buying a 987S.