Hi Greg, just my opinion but I like Trumpet Vine. Here in Florida it is an invasive pain in the a** but when I grew it in Salt Lake City at our house there, and now have planted it in my daughter's yard there, it's quite tame and manageable. So, I'd advise you to drive around your area looking for some - they should be easy to spot at this time of year while they're blooming. If you locate one, see if you can ask the person growing it if they have problems with it.
It doesn't run underground, it just will root if you let a stem lay on the ground. So, if for example you wanted it to ramble along the top of your fence, you'd just have to go along once in a while and lift or cut any errant stragglers so they didn't root where you don't want them. Cut it back maybe every second winter after it loses its leaves, so it can grow nicely again in the spring.
As long as your winters are cold enough to make it go dormant, I don't think you'd have an issue with it planted in the ground. Here, it never goes dormant so it's a headache all the time.
Btw, if you ever want to get rid of a plant, don't just throw it away, give it to Goodwill, Habitat for Humanity, or here I just park my give-away plants out at the curb the day before trash day with a sign "free plant". They always disappear.
