My husband and I stayed at the Main Street Station Hotel & Casino for 2 nights in early March 2007. This is not a "glitzy" huge hotel like many of those found up on the Strip, but it is a nice, older hotel in the downtown area, & it is a good option for travelers on a budget. The main areas of the hotel & casino have a lot of antique charm, & we were pleasantly surprised to find that the rooms had obviously undergone a recent renovation because they were very modern & comfortable.
Check-in was quick & the staff was friendly. Our room was larger than we expected, with the exception of the bathroom, which was small (adequate, but very small). The bed & chairs were very comfortable. Our room looked out toward Fremont Street & the railroad tracks. The only complaint we had about our room was the noise of both passing trains & the fans on the roof of the Main Street casino, which was just below our room (we were on the 6th floor). The train noise wasn't terrible & I don't recall hearing trains go by late at night, but during the day it was noticable. The fan noise was annoying at night, though - we turned on our air conditioner to drown out the fan noise, but that just made it even louder in our room. These noise issues were not a huge problem, but if we were to stay there again we'd probably request a room on the other side of the building or up on a higher floor (a friend travelling with us stayed across the hall & said her room was pretty quiet).
There was no Internet access from our hotel room, however there is a wi-fi area near the player's club off of the casino, plus there is a computer terminal in the lobby available for guest use for a fee.
We ate dinner at the steak restaurant at the Main Street one night. The food was decent, but not excellent. Two of us ordered medium-well steaks & found them to be overcooked & dry, which surprised us since it was a steakhouse restaurant. We also had the breakfast buffet one morning, which we thought was great.
If you are a gambler then downtown is a great place to stay; that is the primary "attraction" in this part of Vegas. We found the Main Street casino to be relatively uncrowded most of the time, which was nice. The casino staff was friendly as well. There isn't much shopping to do in downtown (although there is an outlet mall not far away) & the Main Street does not have a swimming pool, however it's neighbor, the California Hotel, has a rooftop pool that Main Street Station guests may use. We stayed at the Cal last year & I used the pool - it's fine if you just want to swim some laps or lay in the sun, but it certainly does not rival the elaborate pool deck areas of some of the larger/newer hotels in Vegas (up on the Strip, that is).
Fremont Street is a short walk from Main Street Station (walk through the Main Street, through the Cal, then walk one block down the street & you're there). Fremont Street is the place to be at night if you are downtown - check out the free laser light show that plays periodically throughout the evening, gamble your way from one casino to the next, buy a cheap margarita-by-the-yard, etc. There are also numerous other restaurant choices in the hotels on Fremont Street; we had dinner at Grotto at the Golden Nugget one evening where we had a tasty Italian/seafood meal.
Overall we were happy with our downtown hotel choice and will probably stay there again the next time we want to stay in downtown Vegas.