Well, after looking through everybodys suggestions, I think I'm pretty heavily leaning towards the Manfrotto 190XPROB. At $150, that'll leave me some room in my budget to get a decent head to fix to it.
I've spent a good portion of the day looking through all kinds of tripods that have been suggested. I read the article by Thom Hogan, and although it was very informative, his basic premise is just too idealized for anyone that can't drop almost $2000 on a tripod. Whether or not "Hogan Knows Best", JG Coleman knows what he can spend... and $1700 is just waaaaaay too much.
I looked around at Giottos based upon some recommendations here, too. They look great, but it seems that all of them really push the boundaries of my price range when all is said and done... even if I buy them used. There's the opportunity to get them cheaper if I were to start bidding, but I'm really not much for auctions... I just want to buy it and get it done, whether or not I go new or used.
I looked at Vanguards, too... which, admittedly, also look nice and are relatively affordable.
Honestly, as much time as I've spent researching tripods today, I still don't feel like I have a firm grasp on all the considerations... what features I'll need, what head to get, what functions will be necessitated by the type of shooting I do.
So, I'm going with the Manfrotto 190XPROB... I'll see how it goes.
Thank you everyone for your help and sharing your experiences with your own tripods. I really appreciate your time.