Excellent value A review of Comfort Inn
We stayed here for four nights in spring of 2005. The hotel is located right across the Queensboro bridge from Manhattan. (In fact, you can see it easily from the bridge, which is a good way to explain the location to a taxi driver.) There is a subway stop (#7 purple line) right around the corner, and the ride to Times Square is only about 10 minutes. By taxi, it's about $10.
The neighborhood is "not very scenic", but perfectly safe by day. Late at night, a woman might feel more comfortable returning by taxi rather than walking alone from the subway stop. The hotel has a security guard watching the front area, and we left our car parked outside for five days with no concerns.
The rooms were like any other Comfort Inn; clean, reasonably sized, nothing fancy. They have free ethernet internet access, which was very helpful for finding attractions using my laptop. I can't comment on the continental breakfast, as it was always over by the time we were up.
Lastly, I should mention that the hotel staff were unusually friendly, informed, and eager to help. Our stay averaged to about $135/night, and by NY standards, it was an unbeatable deal.