Nah, not really. 'flagship' is Nokia marketing and I don't care if N97 is their top of the line or bottom of the barrel, as long as it offers the feature combination I'm looking for. The rest of the smartphone OS, software, fanc? home screen, widgets, etc is just gravy.
Low RAM is of far more concern to me, especially when RAM is so cheap and easy to get while not being nearly as significant to the software paradigm (ample supply makes it easier for devs and programmers to be lazier while a new CPU/architecture would make it potentially much more difficult, especially if backwards compatibility/emulation is a concern).