Jross, that fly is a Sex Dungeon (Kelly Galloup articulated pattern). I highly recommend his book, "Modern Streamers for Trophy Trout," and I believe he has some videos out as well. Here's a good motivator video
to get you going with streamers. It really demonstrates why streamers are so effective.
And yes, a spinning rod would work although there are plenty of good spots to use a fly rod and streamers in the Smokies with a bit of practice.