A knight will attack different squares than a queen so promoting to a knight of course makes obvious sense in situations that warrant.

A rook or a bishop attack a subset of squares that a queen does, so why would you ever pick one of them instead of a queen? To avoid the stalemate where your opponent is not in check but has no legal moves.