I heard my name popped up on this thread. So I thought I would pop in and say "Hi".
Emily, the Transit Connect in size and shape is very much like the 2000 Renault Kangoo which I have driven in Europe and we could get 3 bikes and 4 people in it. I'm sure 4 bikes wouldn't be a problem with 2 people. I doubt that you could do 4 bikes and 4 people.
Yes, our Sprinter is a biggie but works great for what we need it to do. They do make Sprinters in a shorter length and also not as tall.
Happy car hunting.
Living life like there's no tomorrow.
http://gorgebikefitter.com/
2007 Look Dura Ace
2010 Custom Tonic cross with discs, SRAM
2012 Moots YBB 2 x 10 Shimano XTR
2014 Soma B-Side SS