As always, I appreciate your feedback, Stomme poes.
No, my site is not an e-commerce site. And, yes, I agree that breadcrumbs are needed with E-commerce sites.
I also argue for a breadcrumb-like checkout-step thing that shows, on each step of checkout, where you are and how many steps are left (along with the first page stating what all is needed to checkout, which payment methods are allowed, and what the total cost before shipping is... cost with shipping is better if there's some sane default that most users would choose).
Back to my original post, it seems that the biggest hurdle I need to overcome first - which started rearing it's ugly head yesterday - is fleshing out my content...
Here I went and built this awesome database-driven content site, but now I am starting to see that all content doesn't fit into my current website architecture. Furthermore, I honestly haven't really sat down and planned out what all of my content will be. And, no, this is sloppy planning. Instead it is one of those, "I'll know what I want when I build it?!"
Hopefully most of my final content will fit into what I've already built, however it occurred to me yesterday that there will be content for which I'll either need to restructure the content or build a modified home for it.
As such, I've decided to take a few days off, clear my head, and then go buy a notebook and start re-sketching out my website on paper with content included. And then stepping back, and look at my completed website, and see where any gaps may exist.
Doing all of this will hopefully give me a "clearer" perspective on how my "pretty URL's" really work/function. It will also help me determine if, when, and where Breadcrumbs might be of help.
Anyways, THANKS for all of the suggestions. You guys have still given me some tips that help.