Yeah, parameter sniffing is also a concern and a thing you have to manage on the SQL Server side - it's led to probably the most venerable article on the topic in that community - http://www.sommarskog.se/query-plan-mysteries.html

Neato! If you investigate and find stuff I'd look forward to seeing your analysis, the work you did on standard statements is quite interesting.