I was travelling solo for the weekend and I arrived in Malacca at 10.30am after a 2.5hr from Johor. I wandered around looking for a basic clean hotel that was an easy walk from the action. I stumbled upon Heeren Inn & I asked at the desk about a double room with own bathroom. The rate was RM90 per night which was a lot cheaper than other places I had enquired at. I asked to see the room & it was great; own shower & toilet, double bed, desk, TV and small wardrobe plus air-conditioning and a window which opened. The hoteI is 1 street from Jonkers Walk with lots of restaurants fro breakfast, lunch & dinner and quite a few small bars also. Jonkers walk also turns into a night market every night. I stayed for 2 nights and it was exactly what i wanted at the right price. They also gave me a free parking space at the rear of the hotel.
My recommendation is whenever possible travel to your destination then find accommodation. You can then shop around and get what you want in the right area for the right price.