What is the correct verb after many a man - go or goes?

'Many a' is a singular expression - like 'each' or 'every single' - so it takes a singular verb:

Many a man goes just a little bit crazy when he sees a car he cannot afford.