Awright, lessee here. I own the Delta 66, and I'm quite satisfied with it. I hear the converters on the 1010 sound better than the 66's, so I'm sure it'd be a great card. For a mixer, you could go cheap and of questionable quality (Behringer), somewhat more expensive but with a solid reputation (Mackie), or somewhere in the middle (e.g. Yamaha). I did the latter--I have a Yamaha MX12/4 board (12 channels, 8 mic preamps). I got it for $450, though I saw it for $300 in a Musician's Friend closeout about a month or two ago (d'oh!). It's a solid board. I'd have no problem recommending it.
Logic or Cakewalk would both probably be fine. I use n-Track, which does pretty much everything those do for several hundred dollars cheaper (
www.fasoft.com). Download demos and see what you like.
Do you know anything about your PC's motherboard, i.e., what kind of chipset does it have? VIA chipsets are known to be a problem for DAWs. Find out what kind of chipset you have and e-mail the manufacturer of the sound card you want. See if they'll tell you about compatibility issues.
Now, on to microphones. Of course you can't have too many Shure SM-57s, at about $80 apiece. They're great workhorses. They're great for micing guitar cabs and snare drums, they're pretty good on vocals, I think they're good on toms, and you could mic your kick drum with one of them (Chad Smith did on the Chili Peppers' Blood Sugar Sex Magik). I find that for bass, I get the best results mixing a line in with a mic signal (the SM57 would work well here too). I don't always use the mic track, but it's there if I want it. If I don't have the tracks to spare (such as when I'm recording my band) I just go line in, and that almost always sounds great. If you want a dedicated kick drum mic, look at something like
the Audio Technica ATM25 (Terry Date uses these on kick drums--you may remember him from his work with Fishbone, White Zombie, and Soundgarden (I think)),
the Shure Beta 52,
the Sennheiser e602 (I have this one), or the AKG D112. These are all around $200, and they're designed to pump out a lot more low end than, say, an SM57. For drum overheads, I can recommend the MXL603s ($80 a pop). They're small diaphragm condenser mics, and they sound fine. Just make sure your board has phantom power, or they won't work.
You could use 4 drum mics and come out well--2 overheads, one kick, and one snare. You'll probably have to mess around a lot with placement to make the overheads catch the cymbals, hi-hat, and toms well--I found that an overhead above each drummer's shoulder works best. If you used SM-57s for the kick and snare and MXL603s for overheads, that'd be about $320 total. You could cut that down by using Behringer ECM8000s for overheads. They're about $35 each, and a lot of people here use them. I'm not exactly recommending them, since I've never used them (still waiting for them to come in the mail), but everybody says they work fine.