Let them have Polish did an awesome spun sugar mani, based on the tutorial found on The Polish Well. I really want to try this using blues and purples!
Poliship did a lovely palm tree manicure as part of the Summer Fun Challenge.
The Anglophile in me is completely enamored with this Union manicure from Nailasaurus, and the accompanying tutorial.
Chit Chat Nails added a tutorial of her own for a saran wrap mani.
Over on Chalkboard nails, there's a great example of galaxy nails. If you want to try your own there's a (unrelated) tutorial right here.