In reading around it seems the only real 'benefit' of esters in motor oils is that it helps make them a bit biodegradable and less toxic to aquatic life. It doesn't seem to do anything (so far as I can see) for the lubricating properties of the oil. It may be biodegradable to a degree but it still doesn't mean we can just tip waste oil down the drain
The best and most easily digested article on oil that goes into a reasonable depth can be found on good old Wikipedia. It seems to give a very good account of what synthetic oils are all about too.
Whilst Castrol Magnatec doubtless a very good oil, you'll be paying a lot for the name and fancy packaging. I'll be firmly sticking by my mantra of using bog-standard non-fancy oil bought in bulk at economical cost and changing it at frequent intervals...