There's no magic button to give you a "film" look. 24p can start you off, but there's lighting, composition, movement, etc, etc, through to color grading in the final phase before showing the project publicly.
Keep in mind that if you shoot HD, edit HD, and output that to SD, it'll look quite a bit better than if you had shot it on SD to start with.
If this camera is going to be what you use for a long time, be sure you have something that will grow with you over time. Go HD if you can afford it. You can still shoot SD if you want. But HD has many more advantages. Pulling keys and color grading is infinitely easier with HD (even HDV's limited color space) than SD, for example.
Also, look at Sony's line up. Canon is not the only game in town, and Canon is not necessarily the best game in town today, either. JVC is nice, but they lack compared to Sony and Panasonic. But in the end, it's your decision. Download the spec sheets on all the cameras you're considering, look at the specs yourself. Go find folks locally you can talk to face to face who use these cameras, that's the best thing to do.
Personally, if I had to chose between the XL2 and the XHA1, I'd not think twice about going with the XHA1. As has been stated, the XL2 is really, really old and outdated...