"We'll finally see who are the nerds without a social life!
EDIT: question... in the above sentence, what is the correct form? "who are the nerds without a social life" or "who the nerds without a social life are"?"
Unfortunately you have boxed yourself into a corner. Your original formulation would pass for conventional English, but it is clumsy, not least because you should really say "the nerds without social lives". Your alternative formulation, "who the nerds without a social life are", would cause the English government of England to issue a fatwa against you. It is a betrayal of everything that Winston Churchill, Lady Diana, Lord Beaverbrook, Clement Attlee, George Best, Henry V, and Dan Dare fought for.
You could say "we will finally see the nerds without a social life!", but even that is unsatisfying. The problem is that "finally see" does not strongly imply finding something, but "finally find" is clumsy, and "finally locate" or "finally determine" sound robotic. At this point I would give up entirely. That's why I envy you, because you have the vim to actually create something, even if it is flawed, whereas I am locked into the pursuit of an unattainable perfection.
It pushed, I would scrap the sentence entirely and write either "we will find the King of the Nerds", or "some people think that flight sim fans are nerds who spend hours in front of their computers, instead of partying and having fun with girls, and also drinking. But with three separate scoring arenas, we will finally put that distorted stereotype to rest."
I'm going to proof-read this message, and then proof-read it again.