Have used Opera as my main browser for a long time - much better than explorer. Supports all those things you asked for. I like the Wand feature for filling in passwords, and I also find the auto form filler very usefull. The default skin is a bit dull, but there are loads to download - I use one called xpzolter.
Once you are used to tabbed windows you will not want to go back to IE. However you might also like to check out Avant browser. It uses the IE engine, but also supports tabs, blocks popups etc. This was recommended by VOG recently, thanks, and I've put it on my laptop - seems good.