Recent experiences are:
6.5 is nicer than 5.x
5.x is better supported by stable modules
there are some cracking modules (like CCK and Views) that make it a framework not just a CMS
install is quick and easy, but building it up takes time.
I still haven't got my head round the theming.
it feels like it has loads of potential.
www.workalone.co.uk is now drupal powered and the wiki is now a 'book' that can be edited by authenticated users using mediawiki syntax.
the host you install it on determines some of the facility you can enjoy - e.g. the various revisions and configurations of PHP affect which modules and which version you can run.
what's bad about it remains the same -
modules sometimes clash, it's not always straightforward to see where the new functionality you just added with a module is located.
installing and enabling several modules at once is not a good idea - hosting limits on memory and MySQL configuration can prevent Drupal functioning.
for a user it's a confusing array of menus and a paradigm (nodes) that needs getting used to.
my recommendations:
install it
enable a core module at a time and play with them
enable different levels of user and play with them
add and enable one third party module at a time, be prepared to scrap and start over during this learning and expanding process.