I stumbled upon a series of videos that Visual Sound released a few years back. They basically got Nashville (but not only) studio guitarists in a studio and asked them to show how they used their pedals.
There are tons of creative ideas in those videos, for every style.
My two favorites are probably Kenny Olson…
… and Michael Elsner, who uses his guitar and Visual Sound pedals in a series soundtrack context, creating all sorts of atmospheres:
The Visual Sound Youtube channel has a lot more, including big pedal shoutouts.