Metrolink is pretty OK, off-peak. Good way to get about. But it is not equipped to deal with football crowds. The capacity isn't there. The only way it might work would be if you could persuade a lot of people to arrive 1-3 hours early and depart 1-3 hours late, thus spreading the demand. However, this is not realistic, certainly not for night matches.
I honestly think the solution for City is to have a railway station of its own because that would have the capacity. But it would cost a lot and (at the moment) it would only really be useful for football matches as the day-to-day traffic would be minimal. To justify it, the area probably needs a lot more attractions and ground capacity needs to rise as well.