I would agree, a short and handy carbine like an mp5, arp9, aksu/pp19 or similar would be the go-to. outfit it with a snappy motor and precocking mosfet and not worry about the noise.
I was mainly an outdoor player, but i have played indoor cqb and despite having a well dialled, accurate snappy...