This is a really great niche site that I found a few months ago, called Whats That Bug. While it has nothing to do with software, it does go to show you what a creative niche site can do. They were listed on Weird Web and Yahoo! Picks in 2003.
In any case, what would you do if you saw this in your basement?