Only if you don't exactly wastes boulders in the world to create massive amounts of ammo to use...
if ammo is based off of rounded boulders, then the only way to get them is to build houses, make basements and dig out the walls...

Yeah a well made village would have a ton of boulders to spare, so generally catapults is impossible to use alone and maintained alone.