Louis, here you can find the theming tutorials. You can customize the look and feel in your application by creating your own theme. Basically it's a predefined html container layout which you can style with css.
As long as you have the right people with JS/HTML/CSS3 skills, as Erik said, you can do anything you want. Please look at the customer section of the mendix website for some examples of application built with mendix.