Is it possible in iOS 6 to make banners only appear when the device is active, but self-dismiss upon unlock?
Yes it is possible.  Turn on Do Not Disturb when you are in your phone.  

Or just turn off notifications 

http://www.imore.com/how-customize-notification-center-alerts-your-iphone-and-ipad