Twitter and MySpace aren't niche products. What's a niche social product that hit it big. Github is one of the few examples I can think of, but there's an enterprise component that made that product successful. Also content-based businesses tend to have a very rough time because you're only as good as the content you can support.
