I happened to visit another wonderful nail art blog called Nailside. Jane, the nail artist, is very creative in using tape to create wonderful nail art designs. On her blog you can see what she can do with tape manicure and also a few tutorial on how to do it your own.
Basically, with just regular stationery tape and creativity you can turn your nail into this:
All photos from: Nailside blog.