I have two different opinions, lol.
I am a germaphobe when it comes to hotels -- I can hardly bring myself to sleep in their bedding (I actually used to bring my own comforter & pillow), so if I found a hair in the bathtub and/or bug in the toilet, I would have complained and asked someone to re-clean the room. Would I have stayed there again on another trip? Probably not.
BUT, $40 is a lot of extra money for your hotel room when, like you said, that alone could cover your food cost. If I were in that situation, I would have to stay at a different hotel most likely. If the cost is the actual issue and will affect your budget/make things tight, definitely go with your gut and get your own hotel. Your daughter will be upset most likely but if all you do is sleep there, it won't affect her ability to hang out with the team.