For the niche solutions you mention above check out the StreamInsight component that ships with SQL Server 2008 R2 (currently in beta (as of Feb 2010)).

I think you'll find it meets your needs beautifully. It ships & is licensed as part of SQL Server, but can run as a separate component hence can be configured for way less overhead than running entire SQL stack if you only need the high speed matching bits.