While every team likes a great player, they want one who also has a respect for their fellow athletes. After all, it isn't whether you win or loose, it's how you played the game. People don't want to play sports with an individual who takes the fun out of it.
The most annoying players are ones who don't even try. If you don't want to be there, you don't have to. If you're there, be there to win. This doesn't mean that you have to be a great player. Players can tell when you are trying your best and that makes all the difference.
While, you need to be fully in the game, the game doesn't need to be fully focused on you. Remember that you are a team and not a one man show. Let other players share in the fun, it doesn't matter if they are great players. As stated above, the only thing that matters is that they try their best.
Follow proper sports etiquette. When playing sports that involve concentration like golf and bowling, be respectful. Don't bowl when players on either side of you are taking their turns. Don't be too loud when your fellow golfers or bowlers are concentrating. Just generally be nice and respectful and show that you are a good sportsman not just a player.
One of the best times to show your sportsmanship is when the game is over. Whether you win or loose, you need to remain your composure and remember that you played a good game. Shake the other members hand and if they are being poor sports, don't let it drag you down to their level.
In addition to being respectful to your fellow players, you also need to be respectful to the location. This actually is still showing respect for your fellow players. No one wants to play baseball on a littered field, or play golf on a putting green that is all torn up. If you are playing in a park or public location remember that you aren't the only one who suffers, if you want to tear something up do it in your own backyard.