The roster of writers, artists and musicians who’ve snubbed the Queen reveals as much covert vanity as it does quiet principle