Sinéad O’Connor’s ‘Nothing Compares 2 U’ topped list of Prince songs by women; was at heart of complex relationship between singer and writer