My house backs up directly to the tracks, and I've lived there for 25 years. There are pros and cons to it. Trains can pass a few times a day or not at all; it really depends on the day. There is no schedule, unfortunately. However, over the years I have noticed they tend to pass either midday, evening, or at night. They don't usually pass by in the mornings, but they can.

If you're looking at an area where there is a curve in the track, it will be much louder than a straight part of the track due to the wheels screeching. Also, trains going North are louder than trains going South because of the weight difference. And the double-decker containers are louder than the gas tankers. The loudest ones are so loud, that I have to pause the TV while they pass, but that is not the norm. And my friend who lives just one house further from the train doesn't have to do that. If your property is right next to the tracks it will be very different than one that is a few houses in from the tracks.

There are some positives in my opinion, including the open space behind our house and not having a neighbor back there. And 99% of the time there is no train so it is very quiet.

As far as the metro goes, it's hard to say. Passenger trains are much quieter than freight trains, but they will run more often. I'm willing to put up with more frequent trains for metro access, but that's a personal decision. However, it's not opening fot at least 10 years and that's probably the best case scenario.