Of course there are apps/devices that can benefit by submitting DNS query to specific server.
Take a Roku device for example. It uses the DHCP supplied DNS server (pfSense Forwarder), but also submits a www.google.com query to google TCP DNS 8.8.8.8. Which in my case at lease provides a different set of servers that ping in at 18 ms rather than 148 ms for the ones provided by Level 3 (pfSense DNS forwarder).
That's pretty wordy. May have to read through it a couple times.
There are lots of possibilities. To each there own.