Hmmm... I'm doing a global Sharepoint roll out at the moment.
I have to say from a technical point of view it is a pig of a product, not least because there are so many interdependancies between Sharepoint, SQL and IIS, and the front end is flaky at best when it comes to setting this up. I haven't found any decent documentation for it which explains all this so fixing the inevitable problems is a complete pain in the backside and a bit "press this and see what happens".
The Microsoft training is close to useless, it tells you how to do stuff but not why you're doing it or how it works, so the main problem is working out what the hell you're supposed to be doing in terms of what the users sees, we used a consultancy for the main "webby" bit and now have a template for each roll out.
My main problem with the users is convincing them that the rather slow MOSS server is a better place to put their documents than a shared network drive, also every document they put up has to be approved before anyone can see it regardless of whether they are a document approver or not, which is stupid (and it can't be done in bulk). The only solution I've found so far is to get them to upload all their stuff then delete it from the shared drive.
One big win, however, is global collaboration and project work, here it is the best solution we have by a long way. I'm also seeing a lot more interest in terms of documents which need to be published to the whole company - it is a nice, easy, secure front end for our shop floor guys to look at stuff like risk assessments, ISO documents and company policies etc (as well as providing version control for it).
I am at the moment playing with K2, the workflow tool - this looks promising, with our export business expanding we're getting shipments held up at customs all the time because of incorrect documentation, so modelling the customs requirements of each country would seem like a win - in this regard I see it more as a rapid application development tool than an intranet tool, but more for stuff you wouldn't normally bother building an app to control.
One last area I'm examining is as a sort of lightweight global datawarehouse - I'm playing with the concept of uploading an Excel doc to a website which then populates a database (kind of like Misalea) - looks promising but (again) a bit flaky.