Assult rifle with a scope and a grenade launcher would be the ultimate weapon...
the whole idea in making halo was to make it so there WAS no 'ultimate' combination of weapons, everything has its weakness, its flaw. that's why the rockets travel slowly, that's why pistols suck, that's why the shotgun has nothing over twenty meters. to create a fun balance that relies more on skills than weapons...