North Americans (US, Canada) have gotten away from manual transmissions over the last few decades. Call it laziness, call it manufacturers consolidating costs and cutting back on transmission options. In 1980, 35% of all new US-made autos (not trucks, cars) were sold with manual transmissions in the US. The most recent statistic I saw (~2014) was only 10% are sold with manuals these days. For foreign-made cars, especially European, that number is much higher. VW reports close to 50% of its Jettas and GTIs are sticks. I own both manual and auto vehicles, and driving a stick in a city where commute traffic is horrible is no fun. But the best anti-theft defense these says in America is to buy a manual transmission since kids aren't learning how to drive them anymore, heh.
In any event, for arcade racers like NFS, I see no reason for manual. As others said, it's just manually clicking up and down gears like moving an automatic shift lever...big deal. Racing sims on the other hand like iRacing, DiRT Rally, Project Cars, Assetto Corsa, and GTR2 have full clutch support for true rowing. If you have a wheel with a clutch and a side shifter it makes for some fun and realistic driving. Euro Truck Simulator 2 is a lot more realistic and fun with one. Sim racers like myself often prefer just racing with a controller on arcade racers instead of a wheel since the car physicals are so unrealistic anyway.