Well, I'm back in town and will be taking another crack at getting it running on Thursday afternoon (it's over at a friends house on the other side of town right now).
On your advice, I had him disconnect the battery so the codes will all be cleared by the time I get over there to try and get it running.
At this point I'm thinking it isn't the TPS since I've already tried swapping one off my spare parts car and it made no real difference. I'm thinking that if the MAF is bad then it wouldn't throttle up properly because it wouldn't be correctly measuring the increased airflow - and therefore the ECU wouldn't supply the right amount of fuel to maintain the correct air/fuel ratio. Logically, that would match the symptoms I've seen so far. But if I'm wrong about that or missing something, please feel free to correct my troubleshooting process.
So, based on that theory, today, I pulled the whole top of the airbox assembly (including the MAF) off my parts car to make it quick and easy to swap out the MAF. That will be my next step in trying to troubleshoot this issue.
If swapping the top half of the airbox and MAF doesn't help, the next thing I'll try is to swap out the knock sensor (thanks for that suggestion el_freddo). I just watched a u-tube DIY video that showed me exactly where it is located and how to replace it. I'll pull the knock sensor off my parts car tomorrow and take it with me on Thursday. If swapping the MAF doesn't solve the problem then the knock sensor is next.
Thanks for all the suggestions and advice guys! You've given me some really good pointers on what to check.
The absolute worst-case scenario is that if I can't figure it out & fix it, I'll use my AAA membership to have it towed home where I can work on it at my leisure.
Stay tuned - I'll post back to this thread with updates on my progress and what I find. Thanks again for all the helpful suggestions...