Personally I prefer the middle sized - but if your livestock will be including burrowing types of fish you will need some of the coarse as well - the finer will eventually settle below it - but the super fine stuff is more trouble than it's worth IMO.
Any of the sands will cloud your water to...