A multi-million-pound train station hailed as a beacon of "sustainable transport" has been ridiculed by locals as "anti-motorist".