Well if it's anything like my first time it's going to be really short and a little akward. Not something I'd bother getting a hotel room for, but that was just my personal experience. I'm still together with the same girl, however, and we get a hotel room whenever I visit her at college, so if you think you can pull it off it is a good idea - and why not be optimistic?
As far as student budget hotels we have tried a new one every time and the best so far was Best Western. Nice clean room for ~$80/night. Next time we'll be staying at a Holiday Inn Express which offers a Jacuzzi Suite for $97/night if you book it in advance. If you're only staying a few nights the extra $20 or $25 dollars a night will go a long way.
Good luck and have fun!
