If you aren't smiling at all or you're smiling too big, you won't make a good co-worker.
You won't get hired anywhere if you look too happy or not happy at all. If you've got a big smile on your face, potential employers will think you're too approachable; if you're not smiling at all, you appear to be too serious and uptight for anyone to want to work with you. The ideal profile photos should look relaxed with a small smile indicating that you have a positive attitude.
A study from New York University showed participants images of faces and then asked them who they'd want to advise them on financial matters, and who they thought were weightlifting champions. Most of the participants chose those with slightly happy faces to work with their money and the ones with very serious faces as weightlifters. So unless your dream job includes pumping iron, stick to looking kind of happy.