As Dinesh says a lot of SQL Refactor feedback can be found on the SQL Refactor forum.
The main issue we found with SQL Refactor was in relation to its compatibility with SQL Server 2005 SP2. Shortly after the 1.0 release we discovered that SQL Refactor would disable all of its menus if users had installed the CTP of SQL 2005 SP2 on their machines. Due to the severity of this issue we got a patch out there as soon as we could. And a few weeks ago we formally released SQL Refactor 1.1 which fixed a further 20 minor issues that users had been suffering from.
SQL Refactor does have a few limitations: some refactorings don't support cross database dependencies; it cannot rename service broker objects; and it cannot support every SQL style out there. However, we will work towards fixing these problems, adding new features like lowercase keywords in future releases.
SQL Refactor is available as a full 14 day trial. The best way to find out if it is right for you is to try it out. If you have problems or any feedback at all we would love to hear from you, either here, or on the SQL Refactor forum.
Lead Tester for SQL Refactor
Red Gate Software