i found my dublin ones fantastic, had them for around 2 years now i think. they're smooth soled but they have this grippy rubber with a swirly design on the bottom, they grip very well, and last for ages and ages! xx
If you want really versitile ones for wearing at home Regent Pro- Rustler boots are really good - quite pricy but last AGES and are quite good looking.
Competing - Ariats all the way =D
Ditto for mountain horse protective boots.
They are heavier than normal boots due to the steel toe cap...which has been a real toe saver for me! I bought them for my Equine Dentistry practicals at uni, but now wear them every day for riding too.
loads of grip and the extra weight makes me feel a little more sturdier in the stirrups. I have even managed to polish them up very nice for a few competitions