The thing to understand about about CDN-provided code is that it's your visitors' browser that's making a direct connection to the CDN servers to download JQuery. Since web browsers should cache JQuery and other JavaScript, even in a situation where a CDN is responding slowly it should only be noticeable during their very first page load on your site, and from then on page loads would be much quicker. In addition, many other sites are using Google CDN for JQuery and JQueryUI, so it could well be that any given user will already have them cached by having visiting another site previously.
The only scenario I can envision where self-hosting JQuery/JQueryUI would be consistently quicker than a CDN would be a situation where you have both a beefy web server and clients together on the same fast local area network, as in an Intranet-type deployment. In that case, the gigabit local speeds will definitely trump an internet connection to Google servers for that critical first page hit. I believe this is implied in the self-hosting JQuery article--the envisioned scenario is one where the client may not have access to the Internet at all, making self-hosting mandatory.
Have you considered the possibility that Google is slow in your testing but may be faster from elsewhere? I'd be surprised if Google CDN is slow across the board--we are using the Google CDN but I've not had any reports of slowness. Could it be your DNS lookups that are slow?
I've never tried alternate CDNs, but I did see that JQuery has their own CDN that you test with, at https://code.jquery.com/
I hope that helps,
Jamie