Who best fits the characteristics you're laying out for a good red zone QB? Cam Newton comes to mind-- run threat, good speed on bullet passes, better short range than long range accuracy (though he still might not be accurate enough overall to be the ideal red zone passer).
Anyway, my point is...