Anon gains a superpower

I've always wanted to see what would have happened if Gandalf or Galadriel took the ring

“Yreve emit ew tih mih htiw eht lugrom edalb, eh setalucaje. Eh seunitnoc gniggeb rof erom. Enon fo su era elbatrofmoc gnihcuot mih evila ro daed. M’I yrros ym drol.”

pænus

It wouldn't turn a human invisible because it only turns hobbitis invisible.

See: the intro to the first movie. Isildur, after his victory at Mt Doom, uses the Ring to turn invisible in attempts to escape a group of orcs that attacked his party.

It does, in fact, turn humans invisible too. Isildur being the obvious example, but even the nine rings given to humans had that effect, shifting them to the spiritual / unseen world. That's a whole different ramble, but for now, let's sum it up that there is an unseen world not everyone can sense and influence, but the Maiar (including Sauron) are inherently spiritual beings that took physical shape in the seen world in order to interact with it.

For Sauron, so much of his power was poured into the One Ring that he was no longer able to take physical form without it (though he evidently still had some ability to twist minds even without it). Through the Ring, he had also dominated the nine human Ring bearers and bound them to him, moving them into the spiritual world. Given that they were originally of the seen world, they could take physical form more easily than him, but as his power waned, so did theirs and they eventually disappeared until his power grew once more and allowed them to reappear.

The reason they could still "see" Frodo is that they were attuned to the unseen and could sense him there, with their power over it manifesting in them stabbing his physical form even though it was invisible to mortal eyes.

There is still the question of the Dwarven rings. They were forged first, and it's possible they weren't as refined yet, though the dwarves are also described as more resilient at resisting the dominating effect. My guess is that the fact they were created by Aulë, Smith of the Valar, rendered them less susceptible to the craft of a lesser spirit (Sauron), but I have no evidence.

The one ring gives the wearer the power of what the wearer defines as power. Frodo turns invisible because for a hobbit not being noticed means safety. The ring tells Sam that he could plant as many Apple trees as he likes, even plastering whole middle earth.

In this moment the ring probably tells to Boromir that he could rebuild Gondor to old strength and he might be able to (before giving in to saurons influence).

Generally it will work on any mortal except dwarves.