Wrong result in spice simulation of DC Offset at AC coupled diode
You should know that, because of the reactive elements, there can be some transients that can confuse if left only for a short time. In this case, you can run the simulation with .tran 500u uic (to be sure it starts everything from zero), and make that end resistance 100, as in the original picture, otherwise you'll have to wait even longer. I didn't have your diode, so I just used the ol' BAT54, but that shouldn't make too much of a difference in this case.