SSAS is meant to provide a way to quickly analyze aggregate data. I can't imagine a scenario where any person is doing an analysis and needs to look at a million records at a time.
I agree. Some of what you have said sounds like you understand this well. But others not so much. When I have users pull even 10,000 rows, I ask them what they need that for. Normally there's some calculation that I can provide for them so that they don't need to do that. Strictly speaking from performance, however, pulling a million rows back in one minute seems pretty fast to me.