BSUPC, I have been driving a full size Transit with the high roof for work lately. Not a big fan. It drives like the old vans. Nothing like the Connect. It can haul a lot of stuff and pull a lot of weight, but you definitely know its a heavy duty vehicle. The standard roof model may be a little bit better, but I suspect it will still feel more "commercial" than the Connect. It uses a lot of gas too. I think a good test drive will help you decide.
You didn't mention looking at trucks, but I test drove the Tacoma and the Nissan Frontier before I got my Connect. The Tacoma was way too expensive and the dealers wouldn't even talk pricing. It was pretty much, here it is, take it or leave. The Frontier was ok, but just ok. If a small truck is a possibility you may want to give it a test drive.
I thought about waiting for the new Ford Ranger, but I liked the Connect enough that it wasn't worth the wait to me.
As the others have said, I thought the Metris was too pricey to even look at. I didn't want the NV200 with the CVT, primarily because I wanted the ability to tow a small trailer. I read on the NV200 forum that in addition to the "No warranty" when used for towing, they actually have a problem with a proper supporting structure for a hitch. On the other hand, it gets good reviews so that may be an option for you if you don't need to tow.
I considered the Ram Promaster City. But the Chrysler/Renault history concerned me enough that I just couldn't bring myself to test drive it. Even though I think things have improved with them and I see quite a few of them on the road.
So in the end, the Connect was the best option for me. Good luck with your search and let us know what you get.