Personally, in my unprofessional opinion, oil is oil (for a daily driver).
Run any synthetic you want, change it regularly, and make sure its the right weight for your car. Most damage to engines is done on cold start (especially important when it gets below 0*C) so I would argue run the thinnest oil you can get away with.
Now, having said that, a big reason for running Rotella is that it is an oil designed for diesels. This is nice for the following reasons:
1) Diesel engines typically have longer oil change interval requirements (ie: trucking industry). The oil is "engineered" with this in mind, however, those long intervals can probably be chocked up to the sheer amount of oil (20+ litres) found in the sump.
2) Diesel engine oils have ZDDP/zinc in them still which is a great molecule for protecting from metal on metal contact under extreme pressure. This product has been removed from car engine oils as it is a pollutant. It also may have finally been removed from diesel engine oil, or the change is coming.
3) Focusing on the diesel aspect, the oil is designed to deal with high heat, heavy load applications (big ol' turbo diesel semis).
Having said all that, Shell recently released a T6 Rotella that is 0w40 and that is what I'd go with. I run Rotella in everything (cars, trucks, rally car, road race car) and so far, things are looking good.
A great example of how proper maintenance is more important than "quality" of oil though is BobIsTheOilGuy. Way back in the day, they received a BRAND NEW Camaro SS off the showroom floor. They put over 20,000 miles on it (32k kms), never doing anything further than changing the oil filter at the extended interval suggestions and topping the motor up with the oil lost in doing so. They used the correct weight mobil1 synthetic. Sent oil samples off every filter change. The oil literally didn't wear out in that time. Modern day cars have such good machining practices/sealing inside the engine with such little blowby/leakdown, you don't get nearly the contaminants in the oil. Combine that with much tighter control of engine temperatures/startup and warm up procedures, and you don't get acidic buildup in the oil nearly as much nowadays.
My current daily driver 2004 gmc 1500 has 415k kms on it. Makes 20psi of oil pressure at idle, goes up to 45psi when revving it up. Truck runs like its brand friggin new. Has had regular oil changes at 7k to 10k kms, all mobil1 synthetic, usually crappy fram filters. My dad did the same thing with his 96 gmc 1500 (600k kms on original motor). My 93 had 320k kms on it and only burnt a "teenie" bit of oil, but it was used and abused. I do 10k km oil change intervals, rallycar is every 2 events due to how badly the cyclic idle washes down the cylinders (the oil thins drastically due to how much gas collects in it, smells like a gallon of VP race fuel when I change it).
So yea... hope that helps
TL;DR is use any synthetic (even cheap crappy Canadian Tire stuff) and whatever filter you want. Change every 10k kms or sooner. Your motor will likely run forever at that point if it doesn't have prior damage/extensive wear.