Don't know if "the 110 is the best drive to get for the Mac right now then" but...
Personally... Replaced an ailing 106D that had developed a problem (despite cleaning the lens) with initial recognition of commercial CDs/DVDs, especially the ones that have to be in the drive for the installed application to work. (A dumb concept, if ever there was)
The 110D was widely-available (and affordable) in Europe, easy to install, was recognised by OS X, and is now accepted as "Apple-shipped/supported" by 10.4.6 on this G5 DP2(A).
Note: check the jumpers - put the jumper on the middle pair of pins - 3 'CS' for 'Cable Select' - Pioneer instructions incuded with "OEM" drive are quite helpful - and remove the plastic bezel with "DVD, CD, etc." on it from the front of the tray or it fouls the silver optical drive gate mechanism.
Haven't felt the need to flash it yet, as the original firmware(1.11) works just fine with the stock of modest-speed DVD-RWs that is being used up.
Detailed flashing instructions are in the riposte to this reactionary conservatism here
http://discussions.apple.com/thread.jspa?messageID=2116762#2116762
The 110D recognises all those commercial discs instantly, and would probably burn a beermat, given the chance.