Wow...long thread.
re: the 300D focus
This is a potential problem in my view also. I really like the idea of housing a 300D (it's cheap, the housings are available now, and whilst canon lens port selection is still experimental it shouldn't take long to work out what works with the kit lens).
With my two sessions u/w with the 10D so far, I mainly shot in 'one shot' mode, but found myself at times swithing to AI servo. This means you can release the shutter before the camera achieves focus, useful for fast moving fish where you figure the focus is pretty close and the wide DOF of your wideangle will render the image sharp. With one-shot, or the AI focus of the 300D (which, yes, is definitely one of the 3 selectable focus modes on the 10D), the shutter won't release, and you've missed your shot.
The other thing with the 300D is the lack of the big wheel on the back whichhe tw on the 10D you would use to adjust your aperture. From the comments above, everyone seems to want to shoot in maual mode, so I think you'll find the 2 stage procedure of the 300D a bit frustrating if you change aperture a lot.
So anyway, as I see it, that's two main flaws of the 300D. Otherwise a brilliant camera at an unbeatable price. The first problem in particular is just a firmware cripple done for model differentiation (you can perhaps hack your 300D with a soldering iron?)
In terms of some of the other comments:
Noise: well, there is a graph floating around (Dpreview, I think) saying s2pro has best noise, but I'm a bit sceptical. Most reviews comment on the very low noise of the canons, esp at high iso compared with other dslrs (yes, I have seen the graph btw, I'm just talking about what I see with my eyes). So definitely don't stay away from the 300D because of concerns re:noise.
It's hard buying a canon for underwater because you will certainly be an 'early adopter' as mentioned earlier. I would be really tempted myself to buy a Nikon (ONLY for underwater use - Nikon is a bit behind Canon at present, and not showing any signs of catching up in terms of technology/price/features, IMHO) because of the aforementioned 12-24 lens, houwsing support and the possibilty of TTL with the S2.
However, the 300D will probably achieve enough of a critical mass to get housing manufacturers to increasingly focus on it (not that they're doing too bad with IKE and Aquatica being pretty quick to get their housings out) . Check out photo.net's digital camera of the year poll - 300D is something like 50% of the votes, the d100 is like 10% or less and I don't think the S2 got a vote. Definitely a bit of a different result compared to if we ran a 'Wetpixel DSLR of the year' poll over here 