How gracious, thank you. I do share your interest in how the royals live (and in royal architecture), so it is something I digest as much as I can find. In response to your inquiry about other royal residences - the answer is - it depends on the residence.
At Windsor, the Queen has a private set of rooms in the Queen's Tower (sitting room, bedroom, dressing room, bath), with an audience room adjoining the tower in the south range (usually called the Visitor Apartments). Prince Phillip's also has his own set of rooms further down that range between the Queen's Tower and the Semi-State Rooms (White, Green and Red Drawing Rooms). This is the same general set-up as in Victoria's time - although today I'm not entirely sure what each room is named, nor which ones belong to the Queen or Prince exclusively, and which are shared / common rooms.
At Balmoral, the Queen and Duke's private rooms lie directly above the main reception rooms (Drawing Room, Library). Floor plans I've seen show a series of 5-6 rooms along that range, including bedrooms, dressing rooms and sitting rooms, although not sure how they are laid-out.
I've never seen floor plans (or many photos) of the private quarters at Sandringham nor Hollyroodhouse, so I'm no help there. I do know that at Hollyroodhouse, Victoria and Albert originally used the 1st floor (2nd floor to us Americans) private apartments which were are called the King's Apartments and today open to tour. After Albert's death, Victoria moved to a suite above on the upper floor which might today be the present private royal apartments (but not 100% sure).