"Best" is a hyperbole whether Apex, Cary, Morrisville, etc.
From a practical stand point, if you have zero tolerance for noise, living under a flight path - whether in Cary, Morrisville, Raleigh - isn't for you. Same applies for the trains. Last I checked, the engines on trains and planes don't get activated merely during their sojourn through Morrisville.
I love trains and planes so I am biased I guess.
I love Morrisville. It is *super* convenient for all things that matter to me and my family. I much prefer to avoid the joys of sitting in traffic that comes with living in Cary, Apex, Holly Springs, and every other town that grows because land is cheaper farther away from the job centers. But I guess some people prefer to bond with their vehicles.
It comes down to what you value more... resale value vs more time with family.