Heh, my thoughts exactly. Wes and I met at ASW but didn't chat much, I'll hit him up again.
I'm really pouring a lot of time (and money, I have a full-time friend/employee/programmer whose life I'm funding from my own PPC campaigns, haha) into this thing.
The dream is literally this: you install this thing, enter your logins, and the next screen shows all your campaigns, rev vs spend, ROI, etc. You don't need to input anything else, no tracking links, no ad copy, no nothing. Everything is downloaded from the Google API, Yahoo SEM, scraped from FB, etc. and all the DT networks' stats are pulled from Webservices and AZ's stats from their custom SOAP API.
I use what I have so far for FB and AZ every day, as in I don't even login to FB or AZ at all anymore to check stats. I go to my dashboard and see where each ad's at. All sub ids are aligned (must ensure every ad has a unique sub id of course) and it shows a green/red table cell based on profitability. Love most days waking up in the morning and seeing more green than red of course.
There are some parts that are hard to automate.. one of which is of course creating/updated things on FB. They don't have an API and although I've figured out how to scrape stats across multiple accounts with PHP/cURL, updating bids and creating ads is a different beast. Maybe someday they'll create an API for it, but in the meantime I'm not wading through their mess of Javascript and AJAX calls to figure out how to spoof 'em. I already pulled my hair out and starting drinking after wasting a day doing this, haha.
So yeah, it's all a dream, but we're getting there.. hopefully later this year I might have something to share with everyone, and ideally for free to get feedback. Ping me if you want to talk more, and of course I'll be social as possible at ASE so hit me up there too.