i got the intuos2 and 4 and at work my boss just got me the 5 today. i love the 5 so far. i'm getting used to the touch controls.
as far as drawing functionality, all bamboo models are identical. the splash and connect don't have touch controls which i'm finding very useful for accessing extra control and tools without the need for a keyboard or key shortcuts. the size isn't a huge deal. i have 6x8 tablets and it is plenty big for drawing on 2 22" monitors. i think the 4x6 should be comfortable for 1 monitor.
so if you think the create is too pricey, and you just want the pen functionality, then the splash is the way to go. it is really affordable and you'll be able to do the same things Artwise than the other 2 (don't know about the connect - is it just the splash but wireless?). the intuos 4 doesn't have touch controls and i still love it, tho i'm starting to like the intuos 5 better because of the touch.
i don't know exactly what you want. all of the bamboo's will have the same drawing ability, the only difference otherwise is the size of the tablet which will affect how it feels. do you draw tight small lines or do you like to do longer strokes? all the other options they offer don't affect drawing whatsoever.
sorry, if i didn't give more direct advice.