I've never seen a 'useful' intranet. I'm not speaking something like a team or division's confluence/knowledge base, but an entire company's intranet.

Every one I've ever encountered ends up full of stale info that no one touched in years and half the time it's "Bob's job to keep that up", even though Bob retired 5 years ago.