I have a manual roof, so can't help you much, but visit zpost.com - a lot more guys there with Z's that can help.
BTW: It's a common problem. Water gets into the motor causing it to crap out a lot... I think last I read about it, it was in the neighbourhood of $800, but I could be totally wrong... check zpost.
2007 Z4 3.0si