Find a specific word within a specific folder on a cloud drive?
In the Finder Preferences you can chose to search on your Mac or within the current folder (Finder Preferences > Advanced > When Performing a Search: drop down)
Spotlight searches filenames and file contents.