There's no reason to believe that Wyden and Issa have agreed on pretty much anything before. Just to pick two issues out of a hat, Wyden is pro-choice and backed the health care reform bill; Issa got a 0% rating from NARAL and has a whole page on his Website about everything that he thinks is terrible about Obamacare. The fact that these two guys can come together to oppose this bill means that (a) there is hope for America yet, (b) tech issues really don't break down on left-right lines, at least all the time, or (c) the bill really is objectively awful (probably some combination of the three).
It's also worth noting that proponents of the SOPA aren't all on one side of the aisle either: it was introduced into the House by Lamar Smith, a solid conservative from Texas, and one of the main figures lobbying for its passing has been Chris Dodd, who was a Democratic Senator up until 2010 and who was one of the crafters of the Dodd-Frank financial reform regulation that Republicans hate so much.
SOPA goes to a committee vote tomorrow, though even if it passes that Issa says that the House leadership probably won't bother bringing it to a full vote. Once that's over with, he can get back to investigating the Obama administration to make good theater and everyone can focus on very loudly blaming each other for not extending the payroll tax cut, which is the number one political issue right now for normal humans.