Has there actually been any cases of people finding out where someone lives off the internet and turning up outside their house?

Yep, it can happen. It happened to a friend of mine last year.

The good news is it never went past just words online, mostly for the person that dug that up that info.