Video jockeys: Help, please

Can you video experts tell me what the quality issues are with video recorded onto SD cards et al instead of onto tape and discs. What’s the maximum quality of such digital cameras? I’m asking for a project that would involve a lot of people carrying cameras all the time and so smaller is better, and so is easier. Appreciate the advice.