I have felt that percolated/french pressed coffee keeps me awake more than instant coffee brew.
EDIT: Since it was (validly) pointed out it will depend on the amount, so the amount, that I am comparing is basically what is mentioned on the packet of instant or ground coffee (whichever is the case). As in if my instant coffee sachet says it makes 2 cups of coffee, I use half of it. And if the ground coffee says to use the filtrate of 2 tablespoons for each cup, I do the same.