Having special effects doesn't necessarily mean just cheap thrills. If its done with tought and good design, it actually enhances the user experience - not in the "Wow that is cool sliding effect", but in reducing the amount of time it takes for an average user to interact usefully to do a task.
Similarly a sliding window to reveal additional info is also a effective UI design. Just because it slides gracefully doesn't mean its of no use.