Dean Giustini lists what he believes are the top five pros and cons to OvidSP and also directs us to a tutorial on the new interface from Yale Medical Library.
Currently many libraries are just linking to Ovid's documentation and tutorials, but there are a few libraries who have already created their own documentation and tutorials. For those of you interested in what others are teaching, you might want to check out the following sites.

Online Tutorials:
OvidSP Tutorials – Cushing/Whitney Medical Library, Yale University
OvidSP –Medical College of Wisconsin Library
OvidSP –University of Michigan Taubman Medical Library
Using PICO to search the OvidSP CINAHL Nursing Database – North Colorado Medical Center Medical Library

Documentation / Handouts:
Multiple Search Modes in OvidSP for MEDLINE (and more): What to Expect – Himmelfarb Library
Natural Language Searching Medline (and more) on OvidSP – Himmelfarb Library
RSS Feeds on OvidSP –Himmelfarb Library
OVID databases starter workbook (pdf) –University of Leeds Library
OVID databases advanced workbook (pdf) –University of Leeds Library