I remember being wowed by Beowulf (which I think was the first high profile 3D movie in the most recent wave), and I also enjoyed Avatar in 3D. Other than those two movies I found that 3D ~~detected~~ detracted from the overall experience and I quickly stopped attending 3D showings.
edit: realized I made a typo three days later...embarrassing