I would give our stay at Ekamjot's apartment a 4.5/5 stars, i.e. it was almost perfect for our needs!
The property has been reviewed extensively at this point, and the reviews paint a pretty accurate picture of what it is like to stay here, so I will try to add points I saw mentioned less frequently.
For those a bit worried about the more colourful elements of downtown Vancouver- the building itself feels very safe. You need to use the key fob multiple times to even get to the apartment, including entrance into the building and to use the elevators. What's more you can only access the floor you are staying on, and I believe there is a front of desk / reception tucked away some where.
The other aspect which was a pleasant surprise was the sofa bed- it exceeded my expectations and I was able to fall asleep on it quite easily. As mentioned by others, downtown is noisy so that may wake up the more light sleepers occasionally. All in all a great stay for those needing to be in downtown.