The Club on Playstation 3-but it wasn´t game would awesome,it was quite pushed back by others games,and it s quite old,so it is very logical. And also Lionheart-Legacy of Crusader (on PC).
Club have however still splitscreen (althought team based modes are little dumb when you are only two of us and no possible add of AI bots) and Lionheart-Legacy of Crusader good old LAN co-op-or better it has classic server-client system.But online are both dead.
And also James Bond-Bloodstone,then I try multiplayer last time,it was dead.Definitive dead.So if you want do multiplayer in James Bond game,don´t pick up Bloodstone on PC.Nobody is playing online that (so forget about multiplayer archievemnt on PC).And it have no local support,so it is really which multiplayer part is useless-edit:not sure how many you need to begin match,but if it as it Quantum of Solace,then you could probably do some private match in for example two people....need to look close at that possibility
And last time I played LOTRO,I managed to have been alone in one part of map during my one hour playing of that game(it was in Lone-Lands).Not say that game is dead (then servers would be shutdown),but it was quite strange feeling-see in social panel only my single name.I don´t remember exactly when time it was,but I think some day in working week in afternoon or short before afternoon.