HP Slugga,
Houston scored a whopping 3 points on offense during the 2nd half of the Buffalo meltdown. The offense had something to do with it, wouldn't you say (Though it was PI on that last Buffalo score).
It's been awhile since I've even thought about the Old Run-N-Shoot Oilers. The bottom line is that they underachieved and never sniffed the Super Bowl. And they did that with many Pro Bowlers on both sides of the ball. (238 points allowed in 16 games under Buddy Ryan's system in 1993).
As far as modern football goes, the Rams did that with a good fullback/halfback - Robert Holcombe and a good Tight End - Roland Williams. They weren't featured or anything, but they existed in some of the multiple sets he ran.
Bottom line is - the Houston offense and propensity for costly turnovers cost them the ability to manage important games (Moon interceptions & fumbles - one of the all-time leaders). As far as Red Zone goes, I'll take your word for it.