It was the second week running that Sykes pulled off a game-winning drop-goal after his effort last week against St Helens.
Wakefield won with a lot of help from former Rovers players now playing for Richard Agar. Ben Cockayne (two), Peter Fox and Frankie Mariano all had spells at the East Yorkshire side before moving on in recent years.
Dean Collis and Kyle Wood also crossed over for the Wildcats with Liam Salter, Graeme Horne, Lincoln Withers, Ben Galea and Josh Hodgson scoring tries for Rovers.
Scrum-half Luke Gale kept cash-strapped Bradford in the hunt for the play-offs by inspiring them to a 34-12 win over Huddersfield.
Gale, at the heart of Bradford's attacking play, scored a first-half try and added three conversions to leave the Bulls 18-6 up at the break.
Karl Pryce touched down twice after the interval to give the Bulls some breathing room as Huddersfield lost for the first time in three matches.
Joe Wardle and Leroy Cudjoe scored the Giants' tries.