My thoughts to your thoughts.
Check out this excellent SQLQueryStress utility from Adam Machanic:
http://sqlblog.com/blogs/adam_machanic/archive/2006/10/21/327.aspx