Well I'm not going to write here and tell you that Ghost Rider was the best choice for Nick Cage, but what is going to be said is that he shouldn't give up on the genre as a whole. Nicolas Cage is a great actor he just gets attached to roles that don't fit him and with the money they possibly offer would you say no to free money?
Let's not forget his redeemed factor as Big Daddy in Kick-Ass and with hopeful training flashback cameo's in both Kick-Ass 2 and Kick-Ass 3 movies we can still have hope to see him in a great super hero persona, but then that leaves what other roles he can play? He was slated to play Doctor Strange back when they first had the idea in the 90's but was canned and as you can tell by my casting for Doctor Strange other characters hero or villain fit the role for Nick Cage's talent:
Catman (He has the most fun with anti batman characters)