<p>What level of CPU usage should be considered high for SQL Server? ie 80% 90% 100%?</p>

It really depends on your machine.  The best thing is to monitor the server using perfmon and see when things start to run slowly.  It is normal for SQL to use a lot of CPU under load.