Is the XL2 still a camera worth using? Been offered use of one for a project i have coming up, but not sure if its worth just seeking out a HD camera, the footage is just going to be put onto DVD so tbh, HD would be a waste anyway.
The XL2 is still a good camera & will be fine for a DVD project, however if you're buying it, I would make sure that it's very cheap. For example an early HDV camcorder like a Sony FX1 can be had for less money than a Canon XL2 & will arguably give better results if you film in HD and then downsize to SD in post (will also allow you to crop & reframe slightly).
However if the XL2 is free or very cheap, it's a great bit of kit & will serve you well if you're outputting to DVD!
I agree with several posts on here, camera will be fine, but depends on the use and level of production.
The SD vs DVD argument to me is worthless.. saying HD is waste... HD gives you more latitude with chroma and luma information due to its higher resolution.. which can aid in post production/color correct.. again, only if your production calls for it.
I've worked on plenty of projects where they say at the beginning we are delivering in SD/DVDs.. so we shoot and post in SD.. then afterwards the clients asks for HD versions/masters.. OOPS..
If you have a choice between an SD workflow vs. HD workflow.. I'd choose HD.. but if you are being offered that camera for free for this project, go for it!