> Can Emacs through a press of a button, show a tooltip or a hovering window, directly over the text where my cursor is?

Let me check...

Yes, it can do it. In org mode at least.