Could someone recommend one starting out (something beginner could use and has enough, good functions for continued use into later advanced projects without running into limitations for 'most' projects).

Would be helpful to understand the what limitations might be encountered such at the frequency.