Ala hockey, ever pull goalie to even score or win? Famous examples?
Never.
The closest you get is a “scoring goalie” like Chilavert or Rogério Ceni scoring on a free kick or a penalty OR a desperation move in the last minutes of a match and getting the goalie to go to the box on a corner or free kick.
It isn’t common but in seeking a late game winner goalkeepers may push forward into attack for set pieces like free kicks and corners.
If you substitute off the goalkeeper you need to advise the referee and opposition of who is the new acting goalkeeper. I guess you could say “Nobody” but I’ve never heard of that being done and it would lose the element of surprise. As there are no restrictions on how far out you can score a goal in soccer (i.e. no equivalent of icing as in ice hockey or the 16yd circle in field hockey), and many players could kick the ball in from over halfway, playing with an open net has a higher risk
René Higuita was Columbia’s goalkeeper with 68 caps who seemed to consider using his hands to make saves as something as to be lacking in creativity e.g. his spiderkick saves and would often roam well outside his penalty area and be involved in the play in addition to taking free kicks and penalties. Notwithstanding the occasional monumental gaffe like losing the ball to Cameroon’s Roger Milla in 1990.
It’s very common in desperate knockout games for the goalie to join in the main action in the last few minutes of a game if his side needs a goal - particularly during set pieces as goalies are usually tall and so useful for heading balls into the net. Peter Schmeichel of Manchester United often used to join the opposition’s box during last minute corners and other set pieces - he scored 11 goals in his career.
Here’s an example.
I think you mean scorpion kick. I can only imagine that Capello would explode if Rob Green tried it.
The problem is that it can take a bit of time for the keeper to get back to the goal… and you risk something like this happening 
The drawbacks far outweigh the benefits (if any) of doing so. A soccer pitch is very large; a hockey rink is half the size and made of ice. Any advantage gained in adding one attacking player can easily be negated by good positioning of the opposition’s defenders, plus the huge negative of having an unguarded goal (which is several times larger than a hockey goal). With an unguarded goal and everyone forward someone could fairly easily score from mid-field or even farther.
Not to mention that with red cards and all, many matches are played a man down, which good teams can overcome by altering their strategy, like playing a defensive/counter-strike game.
Two more things:
First is that a soccer goalkeeper isn’t wearing 50 pounds of pads, so they’re able to push up and join the attack themselves if desperation calls for it. There’s less need to sub out the goalkeeper.
Second is that in many competitions (world cup, for instance), teams only get a very limited number of subs (like, 3) for the whole game. So even if you have a sub left at the end of the game, you’d rather take out a tired field player who’s been running for 85 minutes than take out your relatively fresh goalkeeper, even if the goalkeeper isn’t quite as skilled in the field.
Pulling the goalie, as in substituting him out? Like others have said, probably not. The existing goalkeeper moving away from the goal mouth and participating as position player? Yes, like the others have pointed out.
When situations dictate gaining an extra attacker by sacrificing the last line of defense, hockey’s very lax substitution rules and the special equipment a goalie wears tend to lead to actual replacement of the goalie with another player.
In the same situation, soccer’s tight substitution rules and the goalkeeper’s lack of burdensome protective equipment lead to the 'keeper being called on to move up the field and do it himself, instead.
It’s a desperation move, but it does happen.