Halo 4 is the ideal for future reference imo, though CE is my favorite.
Halo CE's is too op for the evolved sandbox. Great visal design.
Halo 2's is a visual downgrade, super weak, and no god damn scope... not ideal imo, but not my least favorite.
Halo 3's fires slowly AND takes little damage AND is inaccurate AND has no scope. Good visual design though, but it's not fun to use which leads to that I avoid using it at all.
Halo 3 ODST's is my third favorite and would be my 2nd for balancing ideal, not great visual design, and slightly inaccurate but it's really not too bad.
Halo Reach's would have been amazing imo if it wasn't for the extreme amount of bloom.
Halo 4's was fast, accurate, good amount of damage. As a sidearm is was obviously worse than the BR, but a skilled player still had a chance with it if, for example, your ammo was out. Or if you had emptied your clip if was great to quickly put in the final shot(s). The visual design as also sweetly classic.
The one bad thing that stops it from being a complete ideal was the sound, it sounds like a toy or something, if they would have used a more ce'ish sound it would have been as close to perect as my brain can handle.
If you are someone who havn't played much Halo 4, I highly recommend just starting up Dawn or something just to get a reminder of how this weapon feels. Or don't, I'm not your dad, IWHB though, ok no I'll stop.