I think people get that "Cary" is the better spot if you need parking or are going to points west of Raleigh. It's kind of like finding out after your first trip to WAS or BOS that you could have done New Carrollton or Route 128 instead. Not the end of the world if you miss it as a newbie/out-of-towner, and every local knows how it works.
I'd say that they need a real "Research Triangle" station, that gets a big parking garage, transit oriented development, and easy rent-a-car / car share / taxi access to the sprawling office parks.
I say put it right here:
https://goo.gl/maps/u6UcNJPZsxS2" onclick="window.open(this.href);return false;, or anywhere along S. Miami Blvd where there's still good access to I-40, RDU Airport (for its services and general vibe of being "in the middle of things", not that anyone'd make connections) and the "orignial" Research Triangle labs (eg IBM), but really, they could pick almost any hotel and call it the "station hotel" and build around it or almost any old office building and knock it down for redevelopment.
With so much of the "last leg" / "first leg" of trips being made by car, the Research Triangle is exactly like the office parks of Suburban MD/DC and South-Suburban Boston (and Metropark NJ, and BWI to some extent) in its need. That the car is often faster than the train makes a "halfway" station even more useful (for folks from the West/South for whom Durham is "too soon" and Cary is "too late" and vice versa from the North)