I am judging this hotel & casino only by downtown Las Vegas standards, so don't expect this to be a three-star stay or a three-star time if you're used to the luxuries of the Venetian or Bellagio.
Fremont is a very interesting casino in the sense that the rooms tend to be nicer than what you would expect (although not really nice in my opinion) and the casino is not as cheap as you think on most days. They lower their table minimums after 12 am and sometimes mid-afternoon. The area is cool at night I suppose since there's such a huge screen, but otherwise this place is extremely smoke filled, 80's and very, very old.
I think the only draw is that they *used* to have a steak & lobster dinner for $8.99 after 12:00 am on week nights. I never partook on the lobster bit but the steak was alright. It's just you can really tell how outdated it is and without any outrageously low tables or deals I don't really see much reason to come visit unless you want some memoirs of 20 years past.