Replying to Mid Range lens recommendations

Hey guys, im looking for a mid range lens around 17-50 or something like that. I have around 500/600 max to spend.

I've been looking at the Tamron 17-50 f2.8 and it gets mixed reviews but i hear alot of people on here like it, anyone have any input on it?

iv looked at some other ones like the sigma and the canon 18-135mm f/3.5-5.6 EF-S IS STM Lens or canon EF 28-135mm f/3.5-5.6 IS Image Stabilizer USM Autofocus Lens

looking to be able to use with glidecam, do want a low f stop, and ill be using it for mostly video! any help is highly appreciated! +k for all