i didn't consider anything other than a 200, however when i bought my 197 my mate had a VXR and i tested a R.
he is my 2p which buying a 197 and 200 is probably worth half a p.
so i have a corsa sport before they did the vxr range and what put me off was my cam belt going and vauxhall washing there hands of me but what i will say is if you want a shouty car then the VXR is the way to go.
for me it looks like its been driven into
halfords on fire backwards (yes i have the cup spoiler) and is clearly marketed at the young uk market. on an uphill circuit it will lap the quickest of the 3 judging on my mates but should it meet a corner you are knackered. not that it wont handle, it just doesn't handle consistently.
as for the 197, lets face it its a girls car, chic and sexy with curves. sedate until provoked and lacks low down torque, so as you will be doing so few miles it may not be for you, unless you are intending to thrash it when cold!!! What it does do is go round corners. The amount of speed you can carry into, round and out with ease is unbelievable.
As for the R, its a bit of an in-betweeny looks nice, build quality, needs thrashing and handles well. However the seats don't go back if someone gets in the back, you can see bugger all out the back and whist the dash is a bit space aged i couldn't help but think they had used a catapult to place stuff with.
all 3 have good and bad points mate, one of your major decisions is do you want to turbo or none, that will narrow it down.
what i will say is i get an immense amount of pleasure of our having the rev counter zipping right round.
good luck mate what ever you choose will be the right decision for you.