I've stayed in worse but I've also stayed in much better. On check in my room had already been paid for but they didn't check closely enough and debited my card for 4 more days plus an incidentals charge which was great to have that money held in a pending state for an entire week. The cleaning ladies spoke no English and showed up at the most random and inconsistent times (1:30pm, 8:30am, 3pm and I finally just gave up and locked the door and they banged on it for 30 minutes).
Tempe is always pretty loud with airplanes, as it is so close to the airport, but the room I stayed in seemed to have less sound insulation than other places I've stayed so it seemed louder than usual and then I got a fantastic surprise of super loud trains adjacent to the hotel that take awhile to rumble past (I was in the army and I'm pretty good at sleeping through almost anything but the only louder thing I've attempted to sleep through was when I had to camp out next to howitzers firing all night). There are multiple trains that go by in the course of the night so don't think you will only hear one so expect several to shake you out of your slumber. This hotel is conveniently located but for nearly the same price the Tempe Mission Palms is a much better location with a much better nights sleep.