Ok guys, it's not that bad. I bought my N9 back in 2011 and I'm still using it. Below is a short list of working apps that rely on internet connection:

- Facebook
everything works except chat (the one integrated in the phone messaging system, the one in the app itself works fine)
- Rocket

- Accounts:
-- CalDAV integration with external callendars, in my case OwnCloud synchronizes flawlessly,
-- Flickr
-- Gadu-Gadu chat client
-- Nokia account (mine is old, I guess there is no way to create a new one)
-- Last.fm - still connects and synchronizes music stats with the last.fm account
-- Picasa
-- Skype, incl. chat
-- YouTube (although I prefer cuteTube2)

- Maps, Navigation and Nokia City Lens still working, only the latter requires internet connection, but still shows accurate data
- Tiny Tiny RSS
- Feeds and Web Feeds
- AP Mobile ans Al Jazeera
- Warehouse
- Butaca
- Allegro, Ceneo (Polish eBay equivalent and price comparison site)
- MeeCast
- CloudGPS - just update providers.ini from here: http://grec.co.nr/priv/cloudgps.zip
- MusiKloud - most of it works fine, except you can't listen to the tracks until you actually download them (some API changes, waiting for the update)