With mkrufky's help, I finally got the Pinnacle 80e to lock. Successfully did a channel scan and it looks like it's finding all the usual suspects.
Now I just need to get the transport stream working from the drx3933j to the em2874, and I'll be watching TV on this sucker.
Man, that was annoying...