My biggest gripe was about how "hard" it was to get things going in a web application project. With 2.0 this problem is already solved. It's not plainly obvious to get to, but a developer from the project pointed me to the SubSonic Tools project (not really sure why it's seperate - kinda seems hidden).
Getting this up and running was pretty straight forward. You download the binary file, close VS 2005 and install the stuff using the included msi installer. You will need to replace your dll with the upgraded dll that is included within these tools (Beta 3 didn't work - even though this is labeled beta 3). From there within VS 2005 you right click on the directory you want to generate files to and choose what you want to do from the SubSonic pull down. Easy as pie, no more messing with Web Pages or compilation issues!
If you have more questions, I suggest downloading and reading the Add-in documentation.