Da, that is precisely the gemara in Sanhedrin under discussion; it uses the term ruach hakodesh, but it clearly means nevuah and is thus understood by both its context and the meforshim. It says “after chaggai zecharya and malachi died, batla ruach hakodesh” – they were neviim, not nust baalei ruach hakodesh. Look at the rishonim there.
But you’re right that no one today has the kind kf ruach hakodesh that applies to kesuvim, like mishlei, tehillim, etc… which were written in ruach hakodesh. Our ruach hakodesh means that either our tzadikim are made privy to things in shomayim or that we are mechaven to the amita shel Torah with the holy thoughts Hashem puts in our heads.