"Has anyone ever tried actually firring a large rocket or even a Katyusha from inside their house, or manoeuvring one up the stairs of an apartment block? "
No ... I can say I haven't tried firing one, or manouvering one up the stairs of an apartment block (certainly not on my life's 'must do' list).
sIx