I see siege starships as a suppressive force, your cannon - they suppress hostile movement without their range.. mostly by blowing guardians and the like to bits
Bomber starship, on the other hand, are more like the cavalry - they go somewhere, and do something.. but try not to get caught in a large scale infantry movement.
The rest of them (fleet, riot mostly, plus support fleet units) are your infantry. They do stuff.