Im sorry, I read this and I have to say this:
Shadow, you sound completely pretentious. You have shot down every major title that has been offered to you and you complain about the market changing leaving you, a minority it seems, out in the cold. I can find many great single player games for you, but you would be "unimpressed" or "lame". I'm sorry, if the best of the best is lame to you, then just quit gaming.
Here is my recommendation. You don't like the internet? Don't ask the opinion of the denizens of it. Go buy a gaming magazine or two and read them, send in your mail and wait for an answer. Sorry large gaming companies are not catering to your every want and need.
Edit: I'm never one to make fun of someone for what they can and cannot afford; I'm a college student, as well. But you seem to buy/try alot of these major releases but yet cannot afford the Live Subscription and/or 50ft cable of Ethernet.
Buy it, make it a home project to run it through the walls or get ceiling clips and clip it above. Cheap, effective, just takes time.
If you have a limited gaming budget, Live is actually a BETTER idea. You can get it for $40 on Newegg, right now, which is $3.07 a month. Add in one game like CoD4 which you could play for 3 months instead of 6 hours... so $60 + 9 = $69 for 3 months worth of gaming. That's a little more than WoW. For 3 months.
I'm sorry about financial restrictions or your dislike for the "common" taste, but best bet at this point: You already know what you want and you know where the market is going. Get over it.