Not for video. Will it work, yes but if you read any of the post about video for DSLR one thing everyone tells people, you need to get fixed aperture zooms. And normally anything with that much range will not be top quality. If you just want to have a walking around lens for causal picture/movie taking it maybe okay. If you are interested in quality it will not be great. The problem is that for quality and speed you will be spending a lot more money.
So asking “is this a good lens for me” with telling what level of photography and what type of shooting you plan to do normally give you what the poster thinks he/she about using the lens in their work, which may or may not be what you need.