Firewall filtering with L7 or DPI for certain content

Can we expect in the future something more serious as SSL and DPI implementation in the future?
Also will be good if there’s a service for providing verified filtering lists.
I am using currently L7-filtering + ADBlock script + DNS static addresses + Umbrella DNS.
I come across this as see L7 filtering failed to remove most of the adds.
I know Pi-hole exists but do not have experience with this yet. Also I am not sure will actually block the adds better than L7.
Any ideas?