I own an XT, which is two generations behind the XSi. Any DSLR will be heads and shoulders ahead of any P&S in any aspect other than compactness. I love my XT, and I have seen no need to upgrade yet, although it goes without saying that newer Canons will be at least as good or better. A XSi would be nice to have, and unless you are a professional photographer or have so much money that you don't know what to do with it, you don't need one of the higher end Canons. Offerings from Nikon, and probably also Sony and Pentax, in the same price range will be more or less the same, but Canon is a good choice due to the ultra large system that is extremely widespread, meaning second hand accessories are readily available.
In addition to the camera, with the DSLR you'll also have to consider what lenses and other accessories to buy. I'd definetely get the 18-55mm IS lens, because you can't beat the value for money that little lens offers. I think Canon probably sells that lens at cost or below in order to be able to offer IS in a starter packet - Sony and Pentax have it in the camera.
Coming from film, I also needed a good ultra wide angle lens for the DSLR, and I went with the Canon 10-22mm. It's an awesome lens but $$$. For my aquarium photography I also needed an off camera flash, and I bought a cheap used 420ex, but splurged on the ST-E2 wireless controller. As far as tele lenses go, there are some real bargains to be had of old excellent quality workhorses - I have the EF 70-210mm 3.5-4.5 USM and it's awesome.
Feel free to check out my site
www.fmueller.com, which has lots of photos all taken with my Rebel XT, and email or PM if you have any more questions.
Frank