Hôtel Aurore is an unpretentious 3-star hotel. It meets the basics well, with a lift serving all floors, and air-conditioned rooms.
About 5 minutes walk from the entrance to Gare de Lyon, finding it isn't too difficult: Rue Traversière is a short street, with Hôtel Aurore pretty much in the middle.
It's good that every floor by the lift has a water cooler, but only the one in reception is actually plugged in, to give chilled water. The plants in the trough on the outside of the hotel look as if they died through neglect a long time ago. Reception appears to be manned into the evening. Plenty of bars and bistros nearby. If you need a bed for a couple of nights in this part of Paris, you could do a lot worse. I found on Expedia that the price jumped around a lot - August 2024.