Video backgrounds and animations are no problems whatsoever. This website builder gets SEO right, too. Portfolio pages, in particular, turn out really good, and most importantly, without being difficult to create. They have many business-focused apps (e.g. for hotels or restaurants) that can make your life easier if you are in one of these industries.
While there are modules and themes that extend the features and looks, novices find it a bit difficult to create a detailed site with it. However, the complexity of Drupal is appropriate for handling huge amounts of data. This makes it ideal for larger corporate and enterprise websites. Just like in WordPress and Joomla, Drupal also allows various extensions in the form of modules. But the difference here is, unlike WordPress users need to leave the system and manually search for the modules before installing them.
Finally, get on the phone with your existing and/or past clients and customers. Tell them you are doing some research to help create additional content and resources to help them, and ask them for 10-15 minutes of their time to learn more about their specific questions and challenges. You’d be surprised how much people are willing to open up when you simply ask them to.