Hmm, I'm not sure if I'd go for either actually.
You gain in portability and convenience, but lose out on image quality. If you're likely to be using your 40D when on holiday with family and friends, who'll be driven nuts by you carrying a bag of lenses, and you asking to stop while you swap...get a superzoom. Even if you buy more expensive ones later, an 18-200/250 will get used when you're 'going casual'.
If you think you'll get away with a 2 lens bag, and the occasional lens swap, I'd personally go for a two lens solution, and get something that goes to 300mm. In my experience, apart from my macro shooting, I tend to use 18-70 for the vast majority of shots, so I'd suggest getting something decent in this range - either image stabilised, 'fast' or both. The Canon 18-55 f2.8 IS would be my luxury choice, but I also note that the brand new Canon 18-55 f3.5-5.6 IS is getting good reviews...and is only £150
http://www.the-digital-picture.com/R...ns-Review.aspx
You're really only going to use 200mm+ for sports and wildlife, and 200mm is too short to do this properly. Both the Tamron and Sigma are f6.3 at the long end, and don't have image stabilisation (unless you go for the OS version of the Sigma). This means that you'll be constantly struggling to get enough light to keep your shutter speed up. How about something like the Canon EF70-300mm f4-5.6 IS, which is both stabilised and faster (and a fairly modest £309).
So, to summarise (and Canonites please correct me if necessary), I reckon an 18-55 f3.5-5.6 IS+ 70-300 f3.5-5.6 IS (total price £459) will wipe the floor with a Tamron 18-250mm (£282).