I was very pleased with the plastic tenor recorder from Yamaha (around $40 Can. iirc) . I wanted a tenor because I had learned the soprano fingering in grade school already, but wanted a less shrill sound. I find it has a lovely peaceful, contemplative tone, that is well suited to playing sad or melancolic Irish music, or more reflective church music, for example. I find it very hard to make it sound happy, though.
Funnily enough, playing the tenor made me rediscover the soprano, which can sound much more joyfull. I found that playing the soprano in a place with no echo or reverberation, like a big carpeted room, or outdoors, really cuts down the shrill/squeak quality, and makes the instrument sound "purer"somehow.
It was a bit of a stretch for my fingers at first., though, expecially on the right hand & the lower notes.
BTW, my three year old loves to hear his favourite songs & nursery rhymes on them, and it was very useful in getting him to participate in singing activities.
At the moment, I don’think my level of playing would justify a wood instrument, though.
I used to play the tenor as part of a consort – its a beautiful instrument with a gorgeous sound, and a lot of what I got to play were the base lines. As for getting a tenor to sound happy, a light prelude or fugue, does it, but you can’t play one of those on your own!
At the moment I have a gorgeous wooden soprano that I bought about 6-7 years ago, which I love to bits. I learnt on a cheapo plastic one, and graduated onto more expensive plastic ones. The tenor I used to play was an Aulos, which whilst not the best, were certainly able to produce a beautiful sound. I think I had something a bit nicer in the consort I was in, but can’t remember off hand.