How filtered indexes could be a more powerful feature

I explore a couple of advantages and a hefty list of limitations with filtered indexes in SQL Server 2008 and above, with links to no less than 36 Connect items.