oronte ... what i want from a phone is
1. looks ... im sorry but the BB is ugly ... and if you find it a pretty phone, i cant imagine what your GF or wife looks like ... hahahahahaha .... (assuming you a male here)...

2. I need a good camera ...
3. Good Nav (garmin vs what on the BB?)
4. Good memory storage
5. Email functions (yeah both phones have good email apps)
6. Decent size (the blackberry's width gets to me, ive had an E71 and hated the size)
7. Good browsing experience
I've had my Storm 2 9520 for just over a month now and the N97 comes nowhere near.
To answer some of your q's
1. Not much to say here, beauty is after all in the eye of the beholder. Personally I like the look of my Storm but then again most touch screen phones look very similiar, they are after all just one big screen.
2. You want a decent camera buy a camera, a cell phone is only good for quick little snap shots anyway. Just my opinion but even a 8MP+ camera in a phone is useless, may be a good sensor but with such a small lense the pics will never be close to a dedicated camera. I do own a Canon DSLR so camera's in phones have always been a bit of a moot point for me.
3. If you are on MTN you get Garmap for the BB (have to download) and BB Maps (which is ***)
4. If you are comparing the N97 to the Storm 2 the N97 does have higher internal storage but both have microSD up to 16Gb, my Storm came with a 16Gb card already installed
5. Nokia has nothing on BB when it comes to email.
6. Size between the two is much of a muchness really, Storm being slightly wider but thinner.
7. The standard browser on the Storm isn't great, rather just load Opera and all the issues are sorted.
Some things where the Storm walks all over the N97
1. Capacative touch screen vs Resistive
2. 7.2 Mbps HSDPA/HSUPA vs 3.6Mbps HSDPA
3. BB has access to BIS and BES
The N97 is a good phone and I do like the fact that it has a full keyboard. The Storm has a technology called SurePress that make the touch screen more like a real keyboard, some people like it and some hate it, personally I find it great as it takes out most of the problems of hitting buttons you weren't trying to hit in the first place.
The N97 was an option when I upgraded but the pay in was more compared to the Storm.
This is the first BB I have owned and so far I am very impressed, most of my previous phones have been HTC's WinMo touchscreens and they have nothing on the Storm 2.