I understand that he is not popular with some due to his off pitch antics when here before but as "wings" says, I would hope that he has grown up by now.
As for his game, I strongly disagree about his contribution. What you get with Leroy is someone with a great deal of determination and fight (of the right sort) on the pitch and in my opinion, he would give us a dimension that we haven't had since he left as he is the last striker for us who properly attacked both the ball and also the near post with any regularity - for a smallish bloke, he didn't half win his share of headers...
In the only full season he played for us in 2004/05, he scored 29 goals in 48 appearances, I don't know about anyone else, but I'd be happy with anything approaching that...
There are a few examples of Leroy for us in the following clip, 45 seconds, 1 min 10 in are fairly typical of what you get but he was also capable of 1 min 40 and 2 mins 20, i.e. an all rounder plus, you get to see Scotty in his prime - ah memories, we haven't played football like that for a while
http://www.youtube.com/watch?v=1vZR7Ie-gbI
Just re-lived that season, especially the play-off semi final 2nd leg against Hartlepool, I was right beehind Goodfellow's header, the place nearly exploded when Christian Roberts scored in injury time..
http://www.youtube.com/watch?v=M7_S9kLZ2FM
I am hoping that with DM in charge, we can finally get the right mix of organisation, discipline and attacking qualities on the pitch. We have at times had 1 and sometimes 2 at the same time but never the 3 together...