I was in a similar situation recently. I decided last minute to go to the ProWein exhibition in Düsseldorf, and of course hotels were either fully booked or very expensive. 200+ euros for a room at Ibis, that kind of thing.
I ended up staying in Frankfurt in a much nicer hotel for half the price, and "commuting" by train. The ICE takes about 1.5 hours, so while not fun, it was manageable.
Maybe try something like this. You won't fundfind a cheap room anyway.