Opinions might vary but I would generally take the standard SATA drive and then get a hold of a USB adapter if needed.
while I use my DVD burners internally I do have a this device (mainly for HDD’s but I have used it on my DVD burners before)… https://vantecusa.com/products_detail.php?p_id=90&p_name=IDE/SATA ; it seems to be okay for limited use but I would assume in general it’s probably best to connect a standard SATA based burner to the SATA ports on the motherboard.
but regardless of which DVD burner you go with, if they are cheap enough, and your quite serious about those needing to be around for many years to come for you to read the discs, it might not be a bad idea to get a couple of DVD burners in case one dies as this way you can further prepare to get the data off the DVD’s if needed just in case that backup burner ever dies and it’s difficult to get access to further DVD reading devices.
but as far as more details between ASUS/Lite-On/LG… I would get some others opinions in these forums. I just know that on the three DVD burners I own, Liteon 1673S (IDE) and a Liteon iHAS324B (SATA) and a Sony Optiarc 7240s(SATA), that the Lite-On’s definitely seem to be a safer choice for reading as I noticed more specifically in terms of AUDIO CD’s, the Liteon is clearly better than the 7240s drive which is so-so as it fairly often does not even acknowledge there is a CD in the drive but seems to work fine with burned DVD’s (and I think CD-R’s to). I can’t personally comment too much on ASUS or LG as I am sure others around here could comment a bit further on those who got a bit more experience with those brand of burners.
but in my opinion… I would not invest too heavily on DVD for data storage besides maybe some of your higher importance data. a regular HDD is probably overall better for general data backup since it’s faster and you get more storage space for less money. either way, never solely rely on one source of backup for your higher importance data as if you do, you might lose that data one day.
as for MDISC DVD’s… it’s probably hard to say how they hold up as they don’t seem to have been around long enough to see how they hold up. but it seems given the accelerated aging tests, the potential might be there they will last a while (my guess is they are probably not worse than standard quality media so if one does not mind paying the premium, ‘maybe’ they are worth considering). but those 1000 year claims I suspect are a stretch. but I guess even if they are close to 50 years or so, that will probably be a lot longer than what really matters as in 50 years, DVD technology will probably be a thing of the distant past and there might be much more reliable ways to store data etc by then. plus, unless your really young right now, you might be dead in 50 years or so and you probably won’t care or have moved onto another technology for data backup.
but for general data backup… standard Verbatim are probably your best all around bet given they are quite reasonably priced and that brand seems to be fairly proven (although nothing is bulletproof) given DVD’s have been around long enough to start to get a feel for their longevity on some level. plus, even if these Verbatim DVD’s fail in say around 20 years, that’s still quite a bit of ones lifespan and it’s not like I would want to rely on DVD media as my sole source of backup as I figure between the DVD’s and hard drives etc, the chances of you losing any of your higher importance data should be slim.