Module for twitter style front page?

That's just three links to three pages. Nothing special.

Create a block with your three menu links in, and position it in a custom block region in your theme (or above content if available).
then create three nodes for your different sections.

You could also use jstools tabs to make it work better with javascript/dhtml and avoid the nasty page reloads that twitter.com has.

--
Ixis (UK) providing Drupal consultancy and Drupal theme design. Check the portfolio.