Would it affect my higher studies and job prospects if I pursue B.Com from a normal college or a good college?

Not at all. It completely depends on the student how well he studies. Maybe during the campus placements reputed colleges will have more recruiters compare to others. But eventually, the person who has enough knowledge can get the placement for sure. All the best. Cheers.