My understanding from a practical point of view is that they can be used indoors when the reflective surfaces are far away enough - bigger spaces, dead enough spaces - people even use shotguns for narration and voice over work in dead vocal booths...
I used Sennheiser MKH60 shotgun indoors for a big TV series project, because we didn't have a hypercardioid at the time and nobody cared - that mic worked even in some glass offices well enough (but not perfect), but had to rely on lavaliers a bit more sometimes - especially for full shots / establishing shots of the space, when dialogue was happening only in those shots... but mostly - the whole show was recorded with MKH60... I loved that mic - it was my first time using it - my initial thought was "oh, that's how you get the "hollywood" sound", because outdoors and in acoustically nice locations it was "ready made" - immediately sounded proper and as dialogue should. And it was nice enough indoors.
(that's the series:
https://www.youtube.com/watch?v=pfSV4zUTKhU or
https://www.youtube.com/watch?v=sP1CdKIlCU0 )
Also - I think the dialogue is most delicate - you hear the coloration the most with the voice, at least to my senses.
So, it is useful to have a hypercardioid for indoor dialogue, but I pulled it off with MKH60, too.
A side-note about shotguns being used in Tiny Desk concerts - that "stage" area might be small, but the whole office in which it takes place is huge, walls far away and the desk area itself has a lot of absorbing/diffusing objects (books, shelves, etc.), it is pretty "dry"... and they use MS stereo shotguns... so not really a single mono shotgun - they add "side" a bit and I am sure that helps with a more natural sound, too...