yes, mi CSS-P designed sites are always in the top results. Recently my girlfriend redesigned her private site from a table-based structure to full CSS positionning and structural markup, her site jumped from google depths to the first page for the same keywords one week later (without any new content).
when I shifted across to css with a large scale site in a competitive field we went from 23rd on a single word term with 3 million results up to 11th within a month...we also went from 2nd to 1st on several two word terms
Do not get Sitepoint's CSS book. I repeat, do not get Sitepoint's CSS book. I looked at this post and then visited Sitepoint. I then decided to see how it was ranked on Amazon.com. Nearly everyone gave it terrible reviews saying it had nothing to do with the title. Buyer beware. You can check it out for yourself and confirm my information.