The Kevlar Mad River Explorer is the first canoe I bought new, and I still have it. It is MRC's jack of all trades tandem canoe, and they sold a ton of them.
It is not particularly fast, not particularly maneuverable, and not particularly suited to solo paddling but it is tolerable on all three counts. It is quite sea worthy and will carry a considerable load and it loads and unloads easily since it has only a single center thwart/yoke in addition to the seats.
You could use the Malecite for tripping solo in relatively calm waters but it is a pocket tandem best suited to day tripping and really doesn't have the capacity to do tandem tripping in.
I have never paddled the Aurora, although I have paddled the Spirit II which is a foot longer and is Wenonah's jack of all trades tandem boat, similar in a number of ways to the MRC Explorer. I can't see how the Aurora would be better than the Explorer in any way other than lighter weight.