Good riding boots probably should have a leather sole, high heel, and mine have a pegged arch which is great for long days in the saddle. Recommend getting custom made ones if you can, only wear them when you ride a horse and look after them and they will last you forever.
I have two pairs of the Ariat Probaby boots. I LOVE THEM. I can wear them to work and stand all day long without any foot pain, and I've never once felt that they were hard to get into a stirrup. I have this pair, and I have a black croc/ pink uppers pair.
I've also got a pair of Ariat ant-eater boots. They aren't as comfortable as the Probaby's, but pretty good.
And I don't even remember the brand of the other boots I have. I'll have to look at home. They're brown smooth leather with pink stitching and a square toe. I have noticed they are NOT as comfortable to wear all day. They are certainly the last pair of boots I go for in my closet.
And I've got an old pair of Double H boots. They're really lasted well over the year of hard use but they were NOT comfortable at all for my feet. They're hanging out at my parent's place as a spare pair of boots when I come home to visit.
I also have a pair of the Ariat Fatbabys, from when they first came out. These are not designed with the riding heel, and I do NOT ride in them. However, they are as comfy as a pair of sneakers. Love them!
But main message to the OP ----> There isn't a certain style you must get (unless you plan on showing at the big time). Just get something that feels comfortable on your feet, has a good riding heel on it, and you feel comfortable getting in and out of your stirrup.