I worked in a consultancy/agency 15 years ago for less than a year (it wasn't for me) and in that short span I witnessed 3 "facebook with a twist" projects. Code was delivered, but they naturally failed to gain any critical mass whatsoever. Also having startups getting a consultancy to do their code was already quite strange.

I specifically remember one of them being "facebook for dogs" and another being for restaurant professionals.