Castle Active Record? Plain NHibernate? Subsonic? Entity? Something like Nettiers?
I'd like to use one, but I don't know enough to decide. Nhibernate seems over kill and complex, but widely used. Subsonic seems neat and easy. But is it stable? I have CodeSmith, and I was pointed to Nettiers, which seems neat as well, but complex too. How do others evaluate and decide what to use? Do you make small simple projects with each to see the features? Eeeny, Meenie, Miney, Moe?
I too prefer NHibernate and agree that if you put a little bit of effort into learning it you'll realise that it isn't as complicated as it first appears. You can go a long way without having to know all of its features.
However, you should always pick the right tool for the job at hand. If you're building an app that has something approaching a true domain model then NHibernate would IMO be the automatic choice. The others you mention are not true object relational mappers but code generators. That in itself is not necessarily a bad thing but you must evaluate when one approach is more appropriate than the other