Everyone's pocketbook is not the same. And some people are just more conservative. Therefore I think you have to follow your heart on this one.
If it were me, I could find a good clean place to spend the night and not spend more than $100 for the motel. Not matter how "posh" it is, the room is not what makes an enjoyable time. We could afford what you are talking about, but the reason we could is because we have always lived frugally.
Whatever you do, I hope you have a wonderful, loving time with your husband.