Yeah, except every game people would try to shoot you down, and with the CG there's only so many spawn-kills you can get before they switch somewhere else and you're defenseless because you're not-facing them.
On small, open maps and in objective modes like Demolition/CTF where there's maybe 3 potential spawn points and you're up against a completely retarded team and if the pre-mapped CG pilot was in an advantageous position the CG was better.
However the AC-130 probably averaged more kills in MW2, since it was always good, had two flares, actually reloaded flares and never had to worry about targets it couldn't hit (within reason, basically the scenarios I mentioned).