As said by many it's very much each to their own, but my long standing choice, especially for German cars (which is about all I seem to do lately) is Menzerna compounds on Sonus pads and I generally get very satisfactory results with a DA polisher.
I battled with many different pad/polish combos when I started detailing and I wish someone had just recommended Menzerna at the time. Would've saved me a lot of trial and error.
I haven't experimented with too many different makes of pads, but of the ones I have Sonus have certainly proven to be the most durable for me.