CFD without HPC

Is bigger always better when it comes to compute power for CFD? Or do you need to think a little differently to take proper advantage of on-demand computing?