You may from time to time come upon a website that you find visually attractive because it follows certain web design trends or because it uses some novel visual effects. You might imagine your own site benefiting from a similar look or design feature. However, you should consider that the site may have been designed with objectives that are entirely different from, and maybe even incompatible with, your own goals.
There will always be trends in web design, and most of them come and go very quickly, and many interfere with search engine optimization (remember when website home pages used Flash as a splash page? SEO death). You should focus on ensuring that you have an effective website design for the purposes your website serves in your business. For many business websites to be effective, their design (1) must not interfere with the SEO, and (2) convert visitors into clients.