Would an oscilloscope not be doing a great job here? 10 MHz sine should be a piece of cake for it. Is it really 65 dBm (~400V in 50 ohm?) or -65 dBm ?
Otherwise, the log detector someone suggested sounds like it could work for you, have a look at
this circuit. It's based on the AD8306 and you basically feed your signal in on one side, and plug the other side into your multimeter. The RSSI dynamic range is -90 dBm to +10 dBm (3 MHz to 160 MHz), with a DC output of +0.4 volts to +2.4 volts. 50 ohms input impedance.
This is the log detector stage of Scotty's spectrum analyzer project and is a proven design.