can someone tell me which is the best web stats software around? wether it be paid or free?

Depends on what kind of information you need. I use AWStats and Webalizer.

I prefer CNStats but use Google Analytics's at the moment.

I mostly use AWstats but I prefer Google Analytics.

AWStats is by far the best in my personal opinion.

Download AWStats free from Template Town:

http://awstats.sourceforge.net/#DOWNLOAD