I'm definitely not stuck on the tool we have. I'll check out the couple you mention. If you have a recommendation that would be great. We pretty much look for general stats, what pages are being hit and how often, etc.
Splunk is a reasonably new tool that makes log files searchable, similar to a google query of your log files. http://www.splunk.com/
mod_log_sql isn't so much an analyzer as it is a different method of storing log files. Instead of dumping them into a file and parsing them from flat text, it stores them directly in an sql database. You can query however you want from the database, and gather any information you want. Since it's input in realtime, you can (assuming enough horsepower on the system) query it in real time to see what people are doing at that instant. One site we have adjusts a "top rated links" based on what people are doing at the time.
awstats is excellent for general logfile analysis of web traffic. There are tons on freshmeat/sourceforge that I haven't mentioned or don't know about that are probably excellent as well.
-- Jim Perrin System Architect - UIT Ft Gordon & US Army Signal Center