I guess I'm in the minority here but I agree with McVay's assessment.
The D held Tampa to 9 points for 59 minutes. And yeah, then they gave up the back breaker on the last drive. Tampa had the ball at their own 42 with 44 seconds left and no timeouts; I agree with McVay's decision to run out the clock and try to lean on his D to close out the game. Unfortunately the D gave up their one TD drive at the end. Derion Kendrick is definitely looking like the weak link; he got abused on both of the last crucial two plays.
The offense is utterly horrid. Aside from the one long pass to Kupp, the offense got what, 130 yards or so? And 2 field goals? Yeah the loss was frustrating, but IMHO the offense again deserves the vast majority of the blame.