Freddette would fill the Eddie House role on a good team but I really think he is really pretty useless on a bad team. He needs a very defined role and the right players around him for him to be a great 3rd-4th option on offense(not as a starter, just whenever he is on the floor) for a team where he can get wide open for his shot.
On a bad team, I think he would just add to the confusion and poor play that is already happening there.