I don't see any advantage to using dynamic store procedures. Also, it would be more difficult to tune and troubleshoot dynamic stored procedures if they constantly change.  In addition, data validation should...

You didn't mention Transactional Replication as a way to keep a warm standby server. It would be interesting to read about pros/cons from the field regarding this method.