I am in the exact same position as you were, missing motor! Did you ever solve the problem with a new motor?Hi all, new to the forum!
Had a search round but not quite found answers yet.
I bought a 2007 clubman last week, a few issues I'm getting through, but this one made me chuckle!
The sunroof didn't work, not a sound. Checked fuse, took light off to check motor... waaahey... found the issue! No motor?
I figured out what motor to get, but is there also a control module attached to it? And does that need programming... or just going through the sunroof reset?
I figure there is quite possibly more problems going on with the sunroof other than just a missing motor.