A JBC iron is spendy but great. The heating element is in the tip, similar to what you described though I don't know if it uses RF. Soldering with it is super easy, requires very little skill, mostly just remembering to use flux.

However, a reflow oven is sooo much easier. I use a Controleo 3 modified toaster oven. It sounds hacky but it really works great. There's not a better solution for the small size at any price.