Well suited to large enterprise website or web application developments. Less well suited to smaller site which would be better catered for by something like Wordpress.
The core modules provide all of the basic content management functionality. You can drag and drop a Blog, Chat, Events, Gallery or versitile Text HTML module onto any page. Once you set a few properties you are up and running. And many of them provide a means of skinning them to match the look and feel of your website design.
If the core modules don't meet your specific needs you can purchase additional modules from third party vendors. If you have some programming experience, you can even create your own custom modules. Christoc's DotNetNuke Module and Theme Development Template makes it easy to get started.
One of the best things about DNN is that the page navigation and user management is already built in. It is complete with friendly URL rewriting and SEO features. DNN authentication can be integrated with Facebook, Google and other authentication providers.
DNN [Platform] is as good as any CMS platform out there today. It's easier to use than WordPress for sophisticated sites and even (once set up properly) for non-technical people to maintain. For novice users without support, it's probably not the ideal solution against WordPress or wix etc. WP has more modules and extensions available. Drupal is a nightmare to use. Sitecore is expensive.