In my case, I initially just built an interface for ThriftDB's HN data; I've recently started building my own data set in MySQL (partly because I wanted to learn how to tune MySQL, partly because I'm starting to expand beyond what's available in ThriftDB). I have a little custom crawler that regularly retrieves the stuff I'm currently after.
I've been looking at using Sphinx (http://sphinxsearch.com/docs/current.html#about) for full text search capability on that data set, but it's not set up yet. It seems to be the most recommended way to handle text search with a MySQL data store.
I wanted to have something that can do a good job of answering questions like, "popular articles about that space mining company from last week" (because that's how my brain works). I probably can't offer any useful information for what you're looking for.
edit: Sorry, to more directly answer your question: "Just curious, when you say that it's easy to roll your own web search engine, are you referring to things like Yahoo BOSS and Common Crawl, or are their other OSS projects / data sources out there I'm not aware of yet?"
Sometime around 2000, full text search of just the contents of your hard drive was still a really icky problem. Programmers spent a ton of time coming up with reasonable ways to do that. It blows my mind sometimes that now we can fairly easily set up our very own SQL database with just a few commands and a little bit of forethought, and then use any one of a number of programming languages to interface with a standard communication protocol to connect to other servers around the world and then download the data, use fairly decent libraries to parse it all, shove it into our own database, and then quickly search the database.
I wasn't really thinking about a particular API or service.