"What can I expect by aeration? More fish? Better water? etc."
An effective aeration system brings oxygen into the water, eliminates stratification and increases circulation. This makes the water at all levels able to support animal and plant life, control algae growth by limiting its food source, and aid decomposition of suspended organic material and muck on the bottom of the lake.
Joey - where are you in NC? If you are close to the mountains at a higher altitude your cfm and psi will need to be adjusted.