experience is the only way to filter the advice you get
I totally agree with you on that point.
The point I’m trying to make is that all the advice the OP is going to get on here will not be a substitute for actually going and seeing and sitting/trying some bikes in the flesh, and hopefully a decent shop nearby will be able to help him out.
And hopefully talking to people in his local area will help point him in the direction of one.
One of the things that worries me most about forums like this is that there is are a lot of opinions, many well informed, many less so, and for exactly the reasons you’ve said, for a beginner this is often a minefield as online you have no way of knowing who is giving the good advice and who isn’t (without experience ;-)), look a this thread for example, it’s already turned into a wheelsize b1tchfest!
This is exactly the kind of situation where a good shop should be of some use, sadly I think you might be right in that a lot of shops are not as good and helpful as they should be, general standards certainly seems to have declined in the last 15-20 years or so, but there are some brilliant ones out there and although you wont get the breadth of opinion that you do online, hopefully you should get some useful advice if they have been in the trade any length of time.