Local order and cluster formation in model fluids with competing interactions: A simulation and theoretical study