I've bought 8 houses over the years.
Each time I've felt about 60% certain it's the one from the details alone.
About 90% after the first viewing.
However I always go back for a second viewing - this time with my "devils advocate" head on.
By which I mean I'm looking for reasons not to buy it. I look past all the things that made me like it in the first place and try and search for reasons not to buy.
Did I look at the neighbours property? Is there a crack at the back of that built in cupboard? Are the floors level? What's the roof look like? Can I see in the attic? Is the cupboard under the stairs musty/damp? Are the windows all in good condition - ie not just painted but not filled and a cosmetic job etc etc
I make sure I go at a different time of day. Houses that can seem cosy in early evening can be dark and gloomy in daytime for example. What's the traffic like in the area etc
It's a big investment to to your heart rule your head.
Out of 8 properties I've had 2, that despite my initial feelings I finally rejected after a second "hard" viewing and I've no regrets. On the 2 I passed on I ended up with properties I loved even more.
So overall it's a home (unless you are an investor) and personally I think you should love a property. If for no other reason, if you do, others likely will also which is good for resale.
But keep your cool and really think hard about what you love vs all the negatives (and there always are some). Moving is expensive so tbh I'd always try and find something that will give you flexibility for the future (I know that's a bit odd from me with 8 moves so far, but some were deliberately bought to fix up and improve within a few years).