I think it already does the fast majority of the plots. To support 'all' of them would become cumbersome I guess; too many variations for specific fields et cetera. Fortunately Mathematica can customize basically any detail of the plot through options which makes it possible to create many different plots, including the one that the OP wants; it's simply scaling the 'second' plot, and replacing some ticks.

OP stands for 'original poster'; i.e. the person who started the thread; you! Most of the time people use these kinds of plots to look for some correlation; (why else would you combine two different plots in to one?). I favour plotting one versus the other or plotting the two data above each other (two stacked plots). Sometimes there are, however, space-requirements of certain journals that forces you into making these kinds of plots unfortunately.

It is a bit tedious, but I would be pretty happy if the biggest obstacle in my data-analysis is giving a frame-tick specification... The links that Vitaliy posted are kind of what I said (replacing the ticks and rescaling some data) except for the Overlay solution. That one returns an 'Overlay' object, not a Graphics object which might not be handy as you can't use an Overlay in Show. So chose wisely...

Please see:

• Generate Plots with Two Vertical Scales

• Overplotting or plotting with two different y axes

• 1 Plot, 2 Scale/Axis

I'm afraid you have to do that manually:

Rescaling your 'second' plot, and then 'faking' the right ticks in the FrameTicks specification.