Don't know any DA42 but Oakland has an ATP school with a seneca, I just did some IR training there in their 172 and saw some of the ATP training/checkride debrief. Looked ok.
Golden Gate
I hear good things about West Valley, but I liked Advantage Aviation at KPAO, and have flown with them recently and had a great time. Just what you'd hope for from a rental club.